Re: creating array of integer[] out of query - how?

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?