selecting from integer[]

Поиск
Список
Период
Сортировка
От Kelly
Тема selecting from integer[]
Дата
Msg-id 3D1D9EA9.3090604@sni.ph
обсуждение исходный текст
Ответы Re: selecting from integer[]
Re: selecting from integer[]
Список 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 по дате отправления: