Re: oid as long type

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Re: oid as long type
Дата
Msg-id Pine.BSO.4.61.0602082026390.23843@leary.csoft.net
обсуждение исходный текст
Ответ на Re: oid as long type  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: oid as long type
Список pgsql-jdbc

On Wed, 8 Feb 2006, Tom Lane wrote:

> Does that matter?  There's an implicit cast from int4 to oid on the
> database side, so I am not clear where the problem really comes in.
>
> regression=# select (-1)::int4::oid;

I was not aware of that.  There is still an issue on the select side, yes
there is a possible conversion from oid::int4, but no one is going to
write their query with that oidcolumn::int4 cast so the driver will have
to selectively remap larger than int values to negative for OIDs, but
not for other types.  I'm still not excited about giving the user a
different representation of the value than is in the database, but now it
at least seems feasible.

Kris Jurka

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: oid as long type
Следующее
От: Tom Lane
Дата:
Сообщение: Re: oid as long type