Re: How can I select rows by comparing an array data type column with multiple values ?

On 06/02/2014 03:54 AM, Arup Rakshit wrote:
> Hi,
>
> Suppose, I have a table as below :-
>
> id | title | content | tags
> ----+--------------+----------------+-------------------
> 1 | sample post | lorem ipsum | {apple,orange}
> 2 | another post | fruits are bad | {apple,hamburger}
> 3 | third post | foo bar | { banana, lemon }
> 4 | third post | foo baz | { watermelon, lemon }
>
> Now I want to select all rows, for which tags will having either one
> or all value from the this array [apple,banana] ? how should I write
> the query using such a set ?
>
> output should select 1,2,3.
> Regards,
> Arup Rakshit

Perhaps the && (overlaps) operator will work best for you. Check out the
available operators at:
http://www.postgresql.org/docs/current/static/functions-array.html

Cheers,
Steve