21 мар. 2019 г. · I'm looking to select data from a table that contains an ID, and an array of values. But in the query results, i want to filter the array and remove values ...

25 мар. 2022 г. · I would like to filter each item by an array of properties, but return the unfiltered properties (just like above) in the same query.

26 июл. 2021 г. · I record each status in an array: select model_id, model, array_agg(id) as jobs, array_agg(statuses) as statuses from jobs group by model,model_id

9 нояб. 2016 г. · Filter on array is most efficient with GIN or GiST index, but neither index type produces sorted output.

24 нояб. 2019 г. · You can use the contains all ?& operator with arrays: select * from r_fav where favorites -> 'favoriteColors' ?| array['Blue', 'Red']

6 янв. 2019 г. · The unique array can also be obtained using the stock array_agg() function with a DISTINCT keyword.

7 февр. 2020 г. · I'm just doing a simple query: SELECT data FROM external_data WHERE id = 1 LIMIT 1 but I don't want to get all the entries in the json array, since there are ...

26 янв. 2023 г. · The idea is to filter rows of the tables based on the value of the expression field. For example, I might want to only leave the rows where there is a column ...

28 февр. 2020 г. · The problem is that it is a hack and produces terrible results and even seq scan when thousands of rows match the condition. However it shows that PG could ...

12 окт. 2015 г. · Is there any way to have a Postgres LIKE query on a ARRAY field? Currently I want something like that: SELECT * FROM list WHERE lower(array_field) LIKE '1234%'