Selects with Array member

Поиск
Список
Период
Сортировка
От Nathan Heagy
Тема Selects with Array member
Дата
Msg-id Pine.LNX.4.21.0101190944540.1908-100000@shell.frontlogic.com
обсуждение исходный текст
Список pgsql-general
I need to know how to select based on a value's membership in an array. I
have tried something like

select * from this_table where this_list *= 'a';

which I found after many obscure searches on google. However pgsql doesn't
know what to do with this operator. Any idea or advice are greatly
appreciated.


   Nathan Heagy



^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   Front Logic   .   Vividworks   .   Cow Comics   .   Thirty-Nine Days



В списке pgsql-general по дате отправления:

Предыдущее
От: Nathan Heagy
Дата:
Сообщение: Selects with Array member
Следующее
От: "Gordan Bobic"
Дата:
Сообщение: Re: Another optimizer question