Re: [SQL] selecting from integer[]

On Sat, 29 Jun 2002, Kelly wrote: > 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

Re: [SQL] selecting from integer[]

Well, you can always just UNION them - I don't know if there's a better way tho. select * from ... union [all] select * from ... union [all] select * from ...; Chris On Sat, 29 Jun 2002, Kelly wrote: > > select * from pg_user where usesysid=(select grolist[1] from pg_group > where groname='my

[SQL] selecting from integer[]

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 t