Re: [GENERAL] max(oid)

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Marc Tardif <admin(at)wtbwts(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] max(oid)
Date: 2000-01-22 04:29:09
Message-ID: 200001220429.XAA28444@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

> 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

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

  • max(oid) at 2000-01-21 23:10:46 from Marc Tardif

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Omkar Prabhu 2000-01-22 08:03:23
Previous Message Cory Kempf 2000-01-22 00:32:11 Re: trouble with the postmaster

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-01-22 04:50:13 Re: vacuum timings
Previous Message Thomas Lockhart 2000-01-22 02:49:20 Re: [HACKERS] Building Documentation under Debian