Search Postgresql Archives

MAX(ROW(...)) - feature request

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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, please.

I'm looking forward to release 8.4 which will introduce window functions.
-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux