Searching through PostreSQL array column

Asked Sep 19 '17 at 05:39

Active Sep 19 '17 at 05:39

Viewed 40 times

I have slide_results table which has tags array column:

tags character varying[] DEFAULT '{}'::character varying[]

I'm searching slide_results by tags in the following way:

select * from slide_results where array_to_string(tags, ',') ilike '%pro%';

Is there simpler way of doing that?

asked Sep 19 '17 at 05:39

Mateusz Urbański

If the duplicate link does not work for you, then state why here and maybe your question can be reopened. – Tim Biegeleisen Sep 19 '17 at 05:44
1

`select * from slide_results where tags @> ARRAY['pro']::varchar[]` – Tim Biegeleisen Sep 19 '17 at 05:45
Other possible duplicates: https://stackoverflow.com/q/46047339/330315 or https://stackoverflow.com/q/45189568/330315 – a_horse_with_no_name Sep 19 '17 at 05:48

0 Answers0