Re: How can I select rows by comparing an array data type column with multiple values ? - Mailing list pgsql-general

From Arup Rakshit
Subject Re: How can I select rows by comparing an array data type column with multiple values ?
Date
Msg-id 1609065.A5C79BjpRE@linux-wzza.site
Whole thread Raw
In response to Re: How can I select rows by comparing an array data type column with multiple values ?  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
> You can use the array "overlap" operator, something like this:
>
>   SELECT .... WHERE tags && ARRAY['apple', 'banana'];
>
> See here:
>
>   http://www.postgresql.org/docs/9.3/static/functions-array.html
>
> Ray.

Yes. It is the one I need really. It worked. Great DB it is. Lots of utility
methods.

--
================
Regards,
Arup Rakshit
================
Debugging is twice as hard as writing the code in the first place. Therefore,
if you write the code as cleverly as possible, you are, by definition, not
smart enough to debug it.

--Brian Kernighan


pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: How can I select rows by comparing an array data type column with multiple values ?
Next
From: Kevin Goess
Date:
Subject: Re: Merge a sharded master into a single read-only slave