Question : I’m looking to select data from a table that contains an ID, and an array of values. But […]
Tag: array
Postgresql: How to pass an array to trigger function in TG_ARGV?
Question : I’ve got some fairly generic Postgres trigger functions that I’d like to re-use across a few different tables. […]
PostgreSQL, finding elements by value in numeric JSON arrays
Question : I have a table defined as: create table dummy (jdata jsonb); I inserted the following two rows: insert […]
Why is intarray’s push `+` so much faster than array-to-element concatenation `||`?
Question : When it comes to using arrays of ints, I always default to using intarray. But, now I’m wondering […]
Modify all array entries in all records of a table at once
Question : I have a schema that involves an array of timestamps. Due to an import problem all the timestamps […]
How do I speed up a string manipulation query where I want to replace characters, extract certain values and update a table with the results?
Question : I am trying to extract information from strings that are presented in a key-value format, with the keys […]
how to search this field in Postgres for an array of characters
Question : I have a users table which is an id, name, and tags. I’d like to search tags for […]
Join on unnested integer array column and count occurrences in array
Question : I am trying to join two tables after I have unnested one of them. The tables are: CREATE […]
Postgresql: Pattern match against array elements?
Question : Is there any way to do a pattern match against the elements of an array in postgresql (9.4 […]
How do You concatenate a value to an array that was retrieved through a query in sql?
Question : I have a table named “mkvtable” that establishes a correspondence between individual strings and arrays of strings: word […]