pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Array of integer
2+ messages / 2 participants
[nested] [flat]

* Array of integer
@ 1999-08-05 15:48 Olivier Ertz <ertz@illite.u-strasbg.fr>
  1999-08-05 16:06 ` Re: [SQL] Array of integer Tom Lane <tgl@sss.pgh.pa.us>
  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 15:48 Array of integer Olivier Ertz <ertz@illite.u-strasbg.fr>
@ 1999-08-05 16:06 ` Tom Lane <tgl@sss.pgh.pa.us>
  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