| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Olivier Ertz <ertz(at)illite(dot)u-strasbg(dot)fr> |
| Cc: | "pgsql-sql(at)postgreSQL(dot)org" <pgsql-sql(at)postgreSQL(dot)org> |
| Subject: | Re: [SQL] Array of integer |
| Date: | 1999-08-05 16:06:18 |
| Message-ID: | 4810.933869178@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Olivier Ertz <ertz(at)illite(dot)u-strasbg(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ross J. Reedstrom | 1999-08-05 16:09:08 | Re: [SQL] primary key view failure |
| Previous Message | Olivier Ertz | 1999-08-05 16:02:15 | Array size |