Re: [GENERAL] max(oid)
От | Peter Eisentraut |
---|---|
Тема | Re: [GENERAL] max(oid) |
Дата | |
Msg-id | Pine.LNX.4.21.0001242109040.525-100000@localhost.localdomain обсуждение исходный текст |
Список | pgsql-hackers |
Btw., this is fixed now. On 2000-01-22, Bruce Momjian mentioned: > Got it. TODO updated. > > [Charset ISO-8859-1 unsupported, filtering to ASCII...] > > 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 > > > > > > > > > -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden
В списке pgsql-hackers по дате отправления: