Re: change of oid values? - Mailing list pgsql-general

From Thom Brown
Subject Re: change of oid values?
Date
Msg-id bddc86150911251100k6f7e5bdcke72f355e67d34baa@mail.gmail.com
Whole thread Raw
In response to change of oid values?  (Yadira Lizama Mue <ylizama@uci.cu>)
List pgsql-general
2009/11/25 Yadira Lizama Mue <ylizama@uci.cu>
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

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: limiting resources to users
Next
From: Merlin Moncure
Date:
Subject: Re: Re: I need help creating a composite type with some sort of constraints.