Re: change of oid values?

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Re: change of oid values?
Дата
Msg-id bddc86150911251100k6f7e5bdcke72f355e67d34baa@mail.gmail.com
обсуждение исходный текст
Ответ на change of oid values?  (Yadira Lizama Mue <ylizama@uci.cu>)
Список 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 по дате отправления:

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: limiting resources to users
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Re: I need help creating a composite type with some sort of constraints.