Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> 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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux