2009/11/25 Yadira Lizama Mue <ylizama@xxxxxx>
Hi,
I'd like to know if the values of postgres's Oids can changes its values for the same object. I want to use them in my aplication, but I'm afraid they could change and I get errors.
I use the field Oid of table pg_type to identify the type of a field in a query. It could bring me errors in the future? For example, the oid value associated to type int4 could change at any future time?
Regards,
Yadira
Why don't you just use pg_typeof() to get the type? And if you want the oid of the type, just do: pg_typeof(fieldname)::oid.
Regards
Thom