Обсуждение: select max(oid)
Hi all, How do I select max(oid) from table; I'm able to to select max(fieldname) from tablename; but not max(oid). Any help be appreciated. __________________________________________________ Do You Yahoo!? Bid and sell for free at http://auctions.yahoo.com
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
> 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. > Added to TODO: * Add max() for oid type -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026