Re: Object IDs in Parse message

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Object IDs in Parse message
Дата
Msg-id CADK3HH+NhuwtaK2sUN9emM4Q+yCETYYX-ANw5v5KXhU3SYrWpw@mail.gmail.com
обсуждение исходный текст
Ответ на Object IDs in Parse message  (Malcolm Matalka <mmatalka@gmail.com>)
Список pgsql-interfaces
select oid, * from pg_type

On Tue, 3 Sep 2019 at 16:01, Malcolm Matalka <mmatalka@gmail.com> wrote:
Hello, I'm implementing my own pgsql client for fun and I'm trying to
understand how to send a Parse message.  The final parameter to Parse is
a series of Int32s with the description:

Specifies the object ID of the parameter data type. Placing a zero here
is equivalent to leaving the type unspecified.

But where do I find the list of object IDs?  Doing some internet
searches didn't bring up much.  Poking around the code I came across the
file:

./src/backend/catalog/pg_type_d.h

And that has a series of OID's with integer values.  Is this the mapping
I'm looking for?

If so, It's not clear how to express some things.  For example there is
a MONEYARRAYOID, but no MONEYOID.  Would I use, for example, NUMERICOID
for money?  If so, why does MONEYARRAYOID exist rather than using
NUMERICOID?

Thanks,
/Malcolm

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

Предыдущее
От: Malcolm Matalka
Дата:
Сообщение: Object IDs in Parse message
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Object IDs in Parse message