Postgres Pro
Downloads
Home   >   mailing lists

Re: Array of Arrays of int - Mailing list pgsql-sql

From Tom Lane
Subject Re: Array of Arrays of int
Date
Msg-id 10431.1115007066@sss.pgh.pa.us
Whole thread Raw
In response to Array of Arrays of int  (Leo Fink <leo.fink@gmx.net>)
Responses Re: Array of Arrays of int
List pgsql-sql
Tree view 
Leo Fink <leo.fink@gmx.net> writes:
> Why does
> select array(select array[1,2]);
> give me an error: "could not find array type for data type integer[]"?

We don't do arrays of arrays.  You seem to be hoping for a 2-D array,
which is something fundamentally different (even though some programming
languages consider them the same ;-))
        regards, tom lane

pgsql-sql by date:

Previous
From: Enrico Weigelt
Date:
Subject: Re: pgtop, display PostgreSQL processes in `top' style
Next
From: "hatuan"
Date:
Subject: Re: Division in Postgre