Re: MAX(ROW(...)) - feature request - Mailing list pgsql-general

From Sam Mason
Subject Re: MAX(ROW(...)) - feature request
Date
Msg-id 20090325180355.GE12225@frubble.xen.chris-lamb.co.uk
Whole thread Raw
In response to Re: MAX(ROW(...)) - feature request  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
On Wed, Mar 25, 2009 at 12:50:01PM -0400, Merlin Moncure wrote:
> 2009/3/25 Grzegorz Jaśkiewicz <gryzman@gmail.com>:
> > least()
> > greatest().
>
> Actually, these answer a different question, OP is interested in using
> aggregate on composite type...

I think Grzegorz was pointing out (rather too tersely in my opinion)
that it would be nice if these were supported as well.  E.g.

  CREATE TABLE foo ( i INT );
  SELECT least('(1)'::foo,NULL);

results in an error.  When this should be valid.

--
  Sam  http://samason.me.uk/

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: 8.3.7 Windows Update Error
Next
From: Tom Duffey
Date:
Subject: could not access status of transaction