Ken Been wrote: > I'm working on a foreign data wrapper and I want to switch based on the column type. > Specifically, if the column type in the external table is the same as in the (locally defined) foreign > table then I can get some speedup for some types. > > Through the ForeignScanState object I can get TupleDesc and AttInMetadata opjects, and > through there I can get the Oid of the column type, but now I'm stumped. How can I programmatically > check whether Oid X refers to type int4, or whatever? > Thanks, but I actually wanted to do it from C code. But anyway I think I found the answer: use the > symbolic constants in catalog/pg_type.h, such as INT4OID. That's fine, there is no problem with doing that. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general