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>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] max(oid)
Date: 2000-01-24 23:49:51
Message-ID: Pine.LNX.4.21.0001242109040.525-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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(at)gmx(dot)net 75262 Uppsala
> > http://yi.org/peter-e/ Sweden
> >
> >
> >
>
>
>

--
Peter Eisentraut Sernanders väg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Graeme Merrall 2000-01-25 00:09:18 Re: [GENERAL] EndTransactionBlock error
Previous Message Peter Eisentraut 2000-01-24 23:49:43 Re: [GENERAL] max(oid)

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2000-01-24 23:50:02 Re: [HACKERS] New install doc
Previous Message Peter Eisentraut 2000-01-24 23:49:43 Re: [GENERAL] max(oid)