Re: libpq: empty arrays have rank 0 in binary results? whatever the type's rank?

Поиск
Список
Период
Сортировка
От Dominique Devienne
Тема Re: libpq: empty arrays have rank 0 in binary results? whatever the type's rank?
Дата
Msg-id CAFCRh-_N066y3r5EE6tzdrsd=eQOU=xEBnr_eUMu=oBfzHDJbQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: libpq: empty arrays have rank 0 in binary results? whatever the type's rank?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
On Wed, Mar 29, 2023 at 3:45 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Dominique Devienne <ddevienne@gmail.com> writes:
> Hi. Selecting/fetching an empty 1D array using a binary-mode PGresult,
> gives me back 12 bytes, and the first 4, the rank, is 0, something I was
> not expecting.

Yeah, empty arrays have zero dimensions.

> PS: On a side note; where can I find the sending code for arrays?
> I didn't find the usual _send() and _recv() functions (but looking on
> github online...)

https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/utils/adt/arrayfuncs.c;h=87c987fb2704761c59333bf8c1fee47e5c14c598;hb=HEAD#l1583

Great. Thanks Tom. --DD

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: libpq: empty arrays have rank 0 in binary results? whatever the type's rank?
Следующее
От: Sebastien Flaesch
Дата:
Сообщение: Re: Using CTID system column as a "temporary" primary key