Re: Extending SQL C-language multidimension arrays

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Extending SQL C-language multidimension arrays
Дата
Msg-id 28511.1339255080@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Extending SQL C-language multidimension arrays  (Chris Schnaufer <chris.schnaufer@pictometry.com>)
Список 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 по дате отправления:

Предыдущее
От: Chris Schnaufer
Дата:
Сообщение: Extending SQL C-language multidimension arrays
Следующее
От: Evan Rempel
Дата:
Сообщение: is there a select for update insert if not exist type command?