User-agent: mu4e 1.0; emacs 26.2
From: Malcolm Matalka <mmatalka@gmail.com>
To: pgsql-interfaces@lists.postgresql.org
Subject: Object IDs in Parse message
Date: Tue, 03 Sep 2019 22:01:28 +0200
Message-ID: <86o9019mjr.fsf@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; boundary="=-=-=";
	micalg=pgp-sha256; protocol="application/pgp-signature"
Precedence: bulk

--=-=-=
Content-Type: text/plain

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

--=-=-=
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQEzBAEBCAAdFiEEQP2ClpgOfnguJZS++DiEc/oMrtcFAl1uxpgACgkQ+DiEc/oM
rtcNXwgAzieu1Jdh91cYiJ9uPjWv+Lp9oGxPc0r42RmUk4ipOXY+aNIuIsr6xjEn
wHOKql3MSeQk6dvuNNgCGeg7aF97N6hnp4isu8JOpfayEDlI/HRJqZUHbupMz6DU
kLk0ZkpS/wIu2eM5OfqXMWwEU7YLJgCGa4XKgL3Z6S5pB1IJSvtmB/20VGs69tM8
8GBgkqvPqV0qa/cRyqeF0EwdfaVkX9by1j30qeGrQctiz6qUQ+wkrR/hnr0PpIDt
DOvkmNJEKSZn7Be6lR/LQdIz75JHoU2+okyL7AubhPzRjH/ufYuTvFSGLM0G7Suk
Hz5yDOIeI4Mw+00fcVwXpaw9GCeppg==
=8Lqs
-----END PGP SIGNATURE-----
--=-=-=--