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

Поиск
Список
Период
Сортировка
От Arup Rakshit
Тема Re: How can I select rows by comparing an array data type column with multiple values ?
Дата
Msg-id 1609065.A5C79BjpRE@linux-wzza.site
обсуждение исходный текст
Ответ на Re: How can I select rows by comparing an array data type column with multiple values ?  (Raymond O'Donnell <rod@iol.ie>)
Список 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 по дате отправления:

Предыдущее
От: Steve Crawford
Дата:
Сообщение: Re: How can I select rows by comparing an array data type column with multiple values ?
Следующее
От: Kevin Goess
Дата:
Сообщение: Re: Merge a sharded master into a single read-only slave