On Oct 22, soundar rajan mentioned:
> How do I
>
> select max(oid) from table;
>
> I'm able to to
> select max(fieldname) from tablename;
> but not max(oid).
There is no max function for the type oid. (Interestingly, casting it to
an int doesn't work either.) You could try to write your own (see help for
create aggregate). There appear to be < and > operators for the type, so
it shouldn't be too complicated.
--
Peter Eisentraut Sernanders vaeg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden