Sam,
> To all: is there a deeper reason why there is no array type for datatype
> record available?
> Not enough demand :)
>
seams reasonable :)
> Try:
>
> CREATE TYPE intarr AS (arr int[]);
> SELECT array(
> SELECT x::intarr FROM (
> SELECT array[2,3]
> UNION ALL
> SELECT array[3,4]) x(a));
>
> and it should do the right thing in 8.3.
>
not exactly :)
ibox=# CREATE TYPE intarr AS (arr int[]);
CREATE TYPE
ibox=# SELECT array(
SELECT x::intarr FROM (
SELECT array[2,3]
UNION ALL
SELECT array[3,4]) x(a));
?column?
-------------------------------
{"(\"{2,3}\")","(\"{3,4}\")"}
(1 Zeile)
.... the result seems to be an array with two strings containing escaped
string-represenations of arrays :)
I guess I will try to solve my challenge without arrays of arrays or records
:)
Thanks for trying,
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
LASIK good, steroids bad?
