Re: where column in ARRAY

Поиск
Список
Период
Сортировка
От Ivan Sergio Borgonovo
Тема Re: where column in ARRAY
Дата
Msg-id 20081022151611.2463d220@dawn.webthatworks.it
обсуждение исходный текст
Ответ на where column in ARRAY  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Список pgsql-general
On Wed, 22 Oct 2008 14:46:35 +0200
Ivan Sergio Borgonovo <mail@webthatworks.it> wrote:

> Without building up a dynamic query is it possible to:
>
> create or replace function t1(a int[]) as
> $$
> ...
> select * from t1 where c in a; // eg in spite of in (1,2,3);
>
> or just obtain a similar effect?

tired rally tired... I didn't understand the example in the manual
where on the left side there is a constant and the column is the
array.
ANY works the other way around as well.

select * from t1 where c=any(a);

too much assembly language in my youth.

Sorry for the noise.

--
Ivan Sergio Borgonovo
http://www.webthatworks.it


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

Предыдущее
От: "Ludovic Levesque"
Дата:
Сообщение: Re: where column in ARRAY
Следующее
От: justin
Дата:
Сообщение: Re: Shopping cart