Re: [GENERAL] max(oid) - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] max(oid)
Date
Msg-id 200001230318.WAA02830@candle.pha.pa.us
Whole thread Raw
In response to Re: [GENERAL] max(oid)  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
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
>
>
>


--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@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

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] max(oid)
Next
From: D Herssein
Date:
Subject: [HELP] - Installing Postgres