pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedArray of integer
2+ messages / 2 participants
[nested] [flat]
* Array of integer
@ 1999-08-05 15:48 Olivier Ertz <ertz@illite.u-strasbg.fr>
0 siblings, 1 reply; 2+ messages in thread
From: Olivier Ertz @ 1999-08-05 15:48 UTC (permalink / raw)
To: pgsql-sql
Hello,
in pg_group, grolist give the list of the members of the group
how can i extract with a select request, not the whole list, but first
the one, the second, etc ... like :
select grolist[i] from pg_group where ...
i is varying from 0..N
Thank you for answering
--
ERTZ Olivier - ertz@illite.u-strasbg.fr - Tel 03 88 35 85 87
------------------------------------------------------------
Etudiant DESS Informatique | Stagiaire EOST/ULP-CGS
Universite Louis Pasteur | Ecole et Observatoire des
STRASBOURG - France | Sciences de la Terre
------------------------------------------------------------
World Wide Web : http://annite.u-strasbg.fr/~ertz
------------------------------------------------------------
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [SQL] Array of integer
@ 1999-08-05 16:06 Tom Lane <tgl@sss.pgh.pa.us>
parent: Olivier Ertz <ertz@illite.u-strasbg.fr>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 1999-08-05 16:06 UTC (permalink / raw)
To: Olivier Ertz <ertz@illite.u-strasbg.fr>; +Cc: pgsql-sql
Olivier Ertz <ertz@illite.u-strasbg.fr> writes:
> in pg_group, grolist give the list of the members of the group
> how can i extract with a select request, not the whole list, but first
> the one, the second, etc ... like :
> select grolist[i] from pg_group where ...
> i is varying from 0..N
In releases through 6.5 you have to write array references as a fully
qualified name:
select pg_group.grolist[i] from pg_group where ...
This is fixed for 6.6...
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-08-05 16:06 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-08-05 15:48 Array of integer Olivier Ertz <ertz@illite.u-strasbg.fr>
1999-08-05 16:06 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox