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


Fri, 21 Jan 2000 23:10:46 +0000 (GMT)
Marc Tardif <admin@wtbwts.com>
max(oid)
> 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@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

Fri, 21 Jan 2000 23:29:09 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [GENERAL] max(oid)
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



Sun, 23 Jan 2000 02:28:59 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: [GENERAL] max(oid)
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

Sat, 22 Jan 2000 22:18:13 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [GENERAL] max(oid)


Peter Eisentraut wrote:

> 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);
>

We need also aggregates for data type TIME
    MAX(time)
    MIN(time)


Josï¿½



Mon, 24 Jan 2000 15:45:11 +0100
Jose Soares <jose@sferacarta.com>
Re: [GENERAL] max(oid)
On 2000-01-24, Jose Soares mentioned:

> We need also aggregates for data type TIME
>     MAX(time)
>     MIN(time)

Thomas, do you think this could be done?

-- 
Peter Eisentraut                  Sernanders vï¿½g 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden




Tue, 25 Jan 2000 00:49:43 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: [GENERAL] max(oid)
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



Tue, 25 Jan 2000 00:49:51 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: [GENERAL] max(oid)
> > We need also aggregates for data type TIME
> >     MAX(time)
> >     MIN(time)
> Thomas, do you think this could be done?

Sure. I'm really stacked up on the ToDo list for 7.0, but it would
only take a couple of hours end to end to get this done (probably less
actually).

A related topic: we should discuss having a real "time with timezone"
type for SQL92 compatibility. It is completely useless imho, since the
SQL92 definition of time zone is so brain damaged (only a constant
hour offset, no concept of daylight savings time, no date context
associated with a time field, etc etc etc). Currently, we swallow the
"with time zone" without comment...

                   - Thomas

-- 
Thomas Lockhart				lockhart@alumni.caltech.edu
South Pasadena, California

Tue, 25 Jan 2000 02:16:23 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: [GENERAL] max(oid)