From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Marcin Krawczyk" <jankes(dot)mk(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: array variables |
Date: | 2008-11-13 13:59:32 |
Message-ID: | 162867790811130559w73aa0448wca6f90c7ff8a13a6@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
2008/11/13 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> writes:
>> 2008/11/13 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>>> 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
[pavel(at)localhost 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sabin Coanda | 2008-11-14 07:38:01 | uuid on windows |
Previous Message | Tom Lane | 2008-11-13 13:52:33 | Re: array variables |