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

From: Dědek Ondřej <ondrasekxy(at)atlas(dot)cz>
To: <pgsql-general(at)postgresql(dot)org>
Subject: MAX(ROW(...)) - feature request
Date: 2009-03-25 11:51:43
Message-ID: 27c7f7dffcbd4949a194a001628674b8@a25be9e6a8db4611adc7949abad81256
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tk421 2009-03-25 12:58:33 Re: Problem with Windows XP Pro SP3 asn PostgreSQL 8.3.5
Previous Message Tk421 2009-03-25 11:44:35 Re: Problem with Windows XP Pro SP3 asn PostgreSQL 8.3.5