Re: [GENERAL] max(oid)
От | Peter Eisentraut |
---|---|
Тема | Re: [GENERAL] max(oid) |
Дата | |
Msg-id | Pine.LNX.4.21.0001221730360.3007-100000@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: [GENERAL] max(oid) (Bruce Momjian <pgman@candle.pha.pa.us>) |
Ответы |
Re: [GENERAL] max(oid)
|
Список | pgsql-general |
On 2000-01-21, Bruce Momjian mentioned: > > Is there a way to use the max aggregate on an oid field? When I try on > > 6.5.3, I get the following error message: > > > > test=> select max(uid) from user_base; > > ERROR: Unable to select an aggregate function max(oid) > > > > If there's any work-around, please let me know. > > Marc > > > > Added to TODO: > > * allow aggregates on oid We already had a TODO item for this and came to the conclusion that * Make type equivalency apply to aggregates will solve this. For right now the user could do the following: INSERT INTO pg_aggregate VALUES ('max', <your user id>, 'int4larger', '-', '-', 26, 26, 0, 26, NULL, NULL); -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden
В списке pgsql-general по дате отправления: