Re: [GENERAL] max(oid)

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Marc Tardif <admin(at)wtbwts(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] max(oid)
Date: 2000-01-23 01:28:59
Message-ID: Pine.LNX.4.21.0001221730360.3007-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2000-01-23 01:30:07 Re: [HACKERS] Re: [GENERAL] Variable case database names
Previous Message Ed Loehr 2000-01-22 23:25:26 Re: [GENERAL] Two "little" things

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2000-01-23 01:29:16 Re: [DOCS] Re: [HACKERS] Building Documentation under Debian
Previous Message Tom Lane 2000-01-23 00:02:43 Doc updates for index cost estimator change