[GENERAL] MAX(ROW(...)) - feature request

2009-03-25 Thread Dědek Ondřej
Hello. Since release 8.2 row comparisons work well - thanks! It would be nice if MIN and MAX aggregate functions could operate on row values, so I could write in SQL: SELECT MIN(ROW(a, b, c, d)) FROM table to find extreme value of ordered set of columns. It should not be hard to implement,

Re: [GENERAL] MAX(ROW(...)) - feature request

2009-03-25 Thread Grzegorz Jaśkiewicz
least() greatest(). -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] MAX(ROW(...)) - feature request

2009-03-25 Thread Merlin Moncure
2009/3/25 Grzegorz Jaśkiewicz gryz...@gmail.com: least() greatest(). Actually, these answer a different question, OP is interested in using aggregate on composite type... merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] MAX(ROW(...)) - feature request

2009-03-25 Thread Grzegorz Jaśkiewicz
2009/3/25 Merlin Moncure mmonc...@gmail.com: Actually, these answer a different question, OP is interested in using aggregate on composite type... true, I was too quick ... :) -- GJ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] MAX(ROW(...)) - feature request

2009-03-25 Thread Sam Mason
On Wed, Mar 25, 2009 at 12:50:01PM -0400, Merlin Moncure wrote: 2009/3/25 Grzegorz Jaśkiewicz gryz...@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