Object IDs in Parse message
Malcolm Matalka <[email protected]> Tue, 03 Sep 2019 22:01:28 +0200
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Message-ID | <[email protected]> |
--=-=-= 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----- --=-=-=--