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

Поиск
Список
Период
Сортировка
Искать
От
Dědek Ondřej
Тема
MAX(ROW(...)) - feature request
Дата
Msg-id
27c7f7dffcbd4949a194a001628674b8@a25be9e6a8db4611adc7949abad81256
Список
Дерево обсуждения
MAX(ROW(...)) - feature request "Dědek Ondřej" <ondrasekxy@atlas.cz>
Re: MAX(ROW(...)) - feature request Grzegorz Jaśkiewicz <gryzman@gmail.com>
Re: MAX(ROW(...)) - feature request Merlin Moncure <mmoncure@gmail.com>
Re: MAX(ROW(...)) - feature request Sam Mason <sam@samason.me.uk>
Re: MAX(ROW(...)) - feature request Grzegorz Jaśkiewicz <gryzman@gmail.com> 
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.
В списке pgsql-general по дате отправления
Предыдущее
От: Adrian Klaver
Дата:
Следующее
От: Raymond O'Donnell
Дата:
FAQ