Arrays advanced usage

Поиск
Список
Период
Сортировка
От Florent Guillaume
Тема Arrays advanced usage
Дата
Msg-id 20010119154644.A4566@twin.efge.org
обсуждение исходный текст
Ответы Re: Arrays advanced usage  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
I just discoverred arrays, and I'm wondering if there's a way to do,
given table t1 (v int4, a int4[]), a query that does in effect :
"select v, i from t1 where EXISTS i SUCHTHAT a[i] = 45;"

I know I can do it with a separate table and a join, but this would
be much nicer.



Also, I wanted to mention that no "reference" is pointed directly from
http://www.postgresql.org/devel-corner/docs/index.html
(you have to go through "postgres" to find it, I think it's not very
intuitive).


Florent

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

Предыдущее
От: Florent Guillaume
Дата:
Сообщение: Re: is PG able to handle a >500 GB Database?
Следующее
От: "Harrelson, CulleyX"
Дата:
Сообщение: RE: couple of general questions