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

From: Arup Rakshit <aruprakshit(at)rocketmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How can I select rows by comparing an array data type column with multiple values ?
Date: 2014-06-02 15:38:00
Message-ID: 1609065.A5C79BjpRE@linux-wzza.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Goess 2014-06-02 16:52:47 Re: Merge a sharded master into a single read-only slave
Previous Message Steve Crawford 2014-06-02 15:32:11 Re: How can I select rows by comparing an array data type column with multiple values ?