Re: Declaring multidimensional arrays in pl/pgsql

From: "Max Zorloff" <zorloff(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Declaring multidimensional arrays in pl/pgsql
Date: 2007-11-29 17:25:53
Message-ID: op.t2kddf1jll0p5y@1-rtt202dnf3uds.mshome.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 29 Nov 2007 21:15:50 +0400, Rodrigo De León <rdeleonp(at)gmail(dot)com>
wrote:

> On Nov 29, 2007 9:33 AM, Max Zorloff <zorloff(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-11-29 17:48:35 Re: HD is flooded by Error Log info
Previous Message Richard Broersma Jr 2007-11-29 17:21:39 Re: viewing definition of "CREATE TYPE name AS ENUM..."