Re: array variables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
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:52:33
Message-ID: 6472.1226584353@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"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.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2008-11-13 13:59:32 Re: array variables
Previous Message Pavel Stehule 2008-11-13 13:47:05 Re: array variables