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?
