selecting from integer[]

From: Kelly <quadratini(at)sni(dot)ph>
To: pgsql-sql(at)postgresql(dot)org
Subject: selecting from integer[]
Date: 2002-06-29 11:48:57
Message-ID: 3D1D9EA9.3090604@sni.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 :)

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-06-29 14:32:02 Re: selecting from integer[]
Previous Message Christopher Kings-Lynne 2002-06-29 04:19:49 Re: creating functional index over multiple columns