Question : DB Fiddle link. I have a many to many table like this: CREATE TABLE house_to_cats ( id SERIAL […]
Tag: array
check if each value of array are equal
Question : I try to get d.id only if all rows with same id have same pday: with dif_zero as […]
Store arrays in table
Question : I’m not sure if this is the best SE section to ask my question. If not, I kindly […]
Using unnest in multiple rows
Question : I have an array column containing information like {a,b,c,a} {a,b,a,b} {b,a,a,b} I want to run unnest on this […]
How to optimize query for text array in PostgreSQL using `@>` operator
Question : I have a column of type text[] and I want to search over this column using this SQL […]
Combine multiple queries into 1 query
Question : I have a message table in Postgres 9.4 that contains a words field of array type, with random […]
Pass a table array as a parameter to an upsert function in postgresql
Question : i have an UPSERT function which works well but i update and insert records in batches, can this […]
Assign result of regexp_split_to_array() to Pl/pgSQL array variable
Question : How do I create an array and then put a result of a function into it? I’m doing […]
SQL Server : refactor schema to avoid repetition
Question : I have an enormous prod SQL Server database : total size = 1.5 TB full backup duration = […]
Use an array returned from a subquery as argument in WHERE clause with ANY function in outer query
Question : A query like this: SELECT * FROM person WHERE person.favorite_number = ANY( ARRAY[ 2 , 3 ] ) […]