Re: [GENERAL] Declaring multidimensional arrays in pl/pgsql

[Max Zorloff]

On Thu, 29 Nov 2007 21:15:50 +0400, Rodrigo De León <[EMAIL PROTECTED]>  
wrote:

On Nov 29, 2007 9:33 AM, Max Zorloff <[EMAIL PROTECTED]> 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.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq