Re: Idea: PostgreSQL equivalent to Oracle's KEEP clause

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Idea: PostgreSQL equivalent to Oracle's KEEP clause
Дата
Msg-id 3766373.1678146043@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Idea: PostgreSQL equivalent to Oracle's KEEP clause  (Ben Clements <benhasgonewalking@gmail.com>)
Ответы Re: Idea: PostgreSQL equivalent to Oracle's KEEP clause  (David Rowley <dgrowleyml@gmail.com>)
Список pgsql-general
Дерево обсуждения 
Ben Clements <benhasgonewalking@gmail.com> writes:
> As shown above, the following calculated column can bring in the city name,
> even though the city name isn't in the GROUP BY:
>    max(city) keep (dense_rank first order by population desc)

You haven't really explained what this does, let alone why it can't
be implemented with existing features such as FILTER and ORDER BY.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Ben Clements
Дата:
Сообщение: Idea: PostgreSQL equivalent to Oracle's KEEP clause
Следующее
От: Siddharth Jain
Дата:
Сообщение: How does Postgres store a B-Tree on disk while using the OS file system?