Re: Declaring multidimensional arrays in pl/pgsql - Mailing list pgsql-general

On Thu, 29 Nov 2007 21:15:50 +0400, Rodrigo De León <rdeleonp@gmail.com>
wrote:

> On Nov 29, 2007 9:33 AM, Max Zorloff <zorloff@gmail.com> wrote:
>> I don't think that works.
>>
>> ponline=# select ('{1,2,3}'::text)::int[];
>> ERROR:  cannot cast type text to integer[]
>
> Can you try:
>
> select ('{1,2,3}'::unknown)::int[];

Thanks, that works fine with 2-dim arrays too.