Re: maxint reached? - Mailing list pgsql-hackers

From Daniel Kalchev
Subject Re: maxint reached?
Date
Msg-id 200204030711.g337B6u05413@dcave.digsys.bg
Whole thread Raw
In response to Re: maxint reached?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Daniel Kalchev
Date:
Subject: Re: maxint reached?
Next
From: Dave Page
Date:
Subject: Re: SHOW ALL as a query result