please help me with arrays

Поиск
Список
Период
Сортировка
От Bo Berkhaut
Тема please help me with arrays
Дата
Msg-id 20001023011020.B39203@caesar.corp.syntext.com
обсуждение исходный текст
Ответы Re: please help me with arrays  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-general
Hi!
Would you please explain me how can I express in PostgreSQL the notion of
"any element of the array". Having a table like:

CREATE TABLE example (name text, slots text[]);

I want to be able to select, for example, all rows such that an element
of example.slots exists equal to example.name.
Something like:

SELECT name FROM example WHERE example.name = example.slots[*];

If I wrong from the very begining and such things should be done
in other way -- please tell me how.
Sorry, if my question is stupid or formulated incorrectly.
Thanks in advance,
  --bo




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Updating pg_attribute - Permission denied
Следующее
От: Tom Lane
Дата:
Сообщение: Re: duplicate key ? (fwd)