selecting from integer[]

Поиск
Список
Период
Сортировка
От Kelly
Тема selecting from integer[]
Дата
Msg-id 3D1D9EA9.3090604@sni.ph
обсуждение исходный текст
Ответы Re: selecting from integer[]  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Re: selecting from integer[]  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-sql
select * from pg_user where usesysid=(select grolist[1] from pg_group 
where groname='mygroup');
select * from pg_user where usesysid=(select grolist[2] from pg_group 
where groname='mygroup');
select * from pg_user where usesysid=(select grolist[3] from pg_group 
where groname='mygroup');

Can those three queries be merged to one query? (and still gives me 
those three rows)
Or do I have to explicitly say grolist[1], grolist[2], etc....

Thanks in advance :)





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

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: creating functional index over multiple columns
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: selecting from integer[]