2008/11/13 Tom Lane <[EMAIL PROTECTED]>: > "Pavel Stehule" <[EMAIL PROTECTED]> writes: >> 2008/11/13 Tom Lane <[EMAIL PROTECTED]>: >>> My example was done in 8.3. > >> I tested it with error: > >> postgres=# select array(select row(a,b) from f); >> ERROR: could not find array type for datatype record > > You left out the cast to a named rowtype --- that's not optional, > unfortunately. >
it works on devel [EMAIL PROTECTED] pgsql]$ psql postgres \psql (8.4devel) Type "help" for help. postgres=# create table foo(a int, b varchar); CREATE TABLE postgres=# insert into foo values(10, 'kuku'),(20,'aba'); INSERT 0 2 postgres=# select array(select row(a,b) from foo); ?column? -------------------------- {"(10,kuku)","(20,aba)"} (1 row) regards Pavel Stehule > regards, tom lane > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql