Re: Extending SQL C-language multidimension arrays - Mailing list pgsql-general

From Tom Lane
Subject Re: Extending SQL C-language multidimension arrays
Date
Msg-id 28511.1339255080@sss.pgh.pa.us
Whole thread Raw
In response to Extending SQL C-language multidimension arrays  (Chris Schnaufer <chris.schnaufer@pictometry.com>)
List pgsql-general
Chris Schnaufer <chris.schnaufer@pictometry.com> writes:
> SELECT getone(ARRAY[[10.1,11.2,12.3],[20.1,21.2,22.3]], POINT(1.0,1.0), 1.5, 1.0, 1.0);
> SELECT getone(ARRAY[[10.1,11.2,12.3],[20.1,21.2,22.3],[31.1,33.2,35.3],[44.1,45.2,46.3]], POINT(1.0,1.0), 1.5, 1.0,
1.0);

> To my way of thinking about these arrays, I should be getting the ARR_NDIM answer of 2 for the first query and an
ARR_NDIManswer of 4 for the second one. 

No, those both look like 2-dimensional arrays to me.  You'd need to look
at the contents of the ARR_DIMS vectors to tell the difference between them.

            regards, tom lane

pgsql-general by date:

Previous
From: Chris Schnaufer
Date:
Subject: Extending SQL C-language multidimension arrays
Next
From: Evan Rempel
Date:
Subject: is there a select for update insert if not exist type command?