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
