Re: generic way to retrieve array as rowset

am  03.01.2006, um 12:37:51 +0100 mailte SunWuKung folgendes:
> When storing data in an array, like this
>
> id    array
> 1,     {1,2}
> 2,     {10,20}
> 3,     {100,200}

Forever 2 Elements in the array? Then:

test=# select * from t1;
 id |    foo
----+-----------
  1 | {1,2}
  2 | {10,20}
  3 | {100,200}
(3 rows)

test=# select id, array_upper(foo,1), foo[idx.i] from t1, generate_series (1, 2) idx(i);
 id | array_upper | foo
----+-------------+-----
  1 |           2 |   1
  1 |           2 |   2
  2 |           2 |  10
  2 |           2 |  20
  3 |           2 | 100
  3 |           2 | 200
(6 rows)


If not: http://www.varlena.com/GeneralBits/105.php
Read the chapter 'Querying and Flattening Array Columns'.


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===