public inbox for [email protected]  

help / color / mirror / Atom feed

From: Dave Cramer <[email protected]>
To: Malcolm Matalka <[email protected]>
Cc: [email protected]
Subject: Re: Object IDs in Parse message
Date: Tue, 3 Sep 2019 16:02:24 -0400
Message-ID: <CADK3HH+NhuwtaK2sUN9emM4Q+yCETYYX-ANw5v5KXhU3SYrWpw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

select oid, * from pg_type

Dave Cramer

[email protected]
www.postgresintl.com


On Tue, 3 Sep 2019 at 16:01, Malcolm Matalka <[email protected]> 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
>

view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Object IDs in Parse message
  In-Reply-To: <CADK3HH+NhuwtaK2sUN9emM4Q+yCETYYX-ANw5v5KXhU3SYrWpw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox