| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Peter Krauss <ppkrauss(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: looking for an array-extract-item-as-it operator |
| Date: | 2016-01-06 22:50:48 |
| Message-ID: | 14748.1452120648@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Peter Krauss <ppkrauss(at)gmail(dot)com> writes:
> I need to access an array-item from an array of arrays.
Multi-dimensional arrays in Postgres are not "arrays of arrays".
If you persist in thinking they are, it's mostly going to lead you
astray about what will work or not.
Having said that, you might find that plpgsql's
FOREACH ... SLICE ... IN ARRAY ... LOOP
construct would help you, if you need to iterate through the
rows sequentially.
http://www.postgresql.org/docs/9.4/static/plpgsql-control-structures.html#PLPGSQL-FOREACH-ARRAY
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2016-01-06 23:42:35 | Re: No Issue Tracker - Say it Ain't So! |
| Previous Message | Peter Krauss | 2016-01-06 22:40:52 | looking for an array-extract-item-as-it operator |