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

["Massa, Harald Armin" <chef@xxxxxxx>]

Sam,

No, as depesz says it's not doing that.  Depending on what you want out
you can get most of the way by having an array of ROWs that contain an
array of integers.  You just need to change:

the sad thing is:

  select array(
 select x from (
 select array[2,3] as a
 union
 select array[3,4] as a ) x);

ERROR:  could not find array type for datatype record

... I remember being there before :( arrays of rows are also not available.

To all: is there a deeper reason why there is no array type for datatype record available?

  [1] http://www.postgresql.org/docs/current/static/sql-createtype.html

Thanks for the hint with CREATE TYPE, especially the lines

"""
Whenever a user-defined type is created,     PostgreSQL automatically creates an     associated array type, 
"""
fills me with joy. ;)

Thanks to depesz & you,

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?