Re: array variables - Mailing list pgsql-sql

From Tom Lane
Subject Re: array variables
Date
Msg-id 6472.1226584353@sss.pgh.pa.us
Whole thread Raw
In response to Re: array variables  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Responses Re: array variables
List pgsql-sql
"Pavel Stehule" <pavel.stehule@gmail.com> writes:
> 2008/11/13 Tom Lane <tgl@sss.pgh.pa.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.
        regards, tom lane


pgsql-sql by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: array variables
Next
From: "Pavel Stehule"
Date:
Subject: Re: array variables