Re: maxint reached?

Поиск
Список
Период
Сортировка
От Daniel Kalchev
Тема Re: maxint reached?
Дата
Msg-id 200204030711.g337B6u05413@dcave.digsys.bg
обсуждение исходный текст
Ответ на Re: maxint reached?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
>>>Tom Lane said:> Daniel Kalchev <daniel@digsys.bg> writes:> > So in essence this means that my best bet is to again
dump/reloadthe > > database...> > Either that or fix your queries to cast the literals explicitly.
 

Sorry for the incomplete reply:

this does not work:

customer=# select max(oid) from croute;    max     
--------------2144025472
(1 row)

this does work:

customer=# select oid(max(oid)) from croute;   oid     
------------2150941824
(1 row)


weird, isn't it? I guess max should return the same type as it's arguments, no?

Daniel



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

Предыдущее
От: Daniel Kalchev
Дата:
Сообщение: Re: maxint reached?
Следующее
От: Dave Page
Дата:
Сообщение: Re: SHOW ALL as a query result