Search Postgresql Archives

Re: Declaring multidimensional arrays in pl/pgsql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

On Nov 29, 2007 9:33 AM, Max Zorloff <zorloff@xxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux