Postgres Pro
Downloads
Home   >   mailing lists

Re: Idea: PostgreSQL equivalent to Oracle's KEEP clause - Mailing list pgsql-general

From Tom Lane
Subject Re: Idea: PostgreSQL equivalent to Oracle's KEEP clause
Date
Msg-id 3766373.1678146043@sss.pgh.pa.us
Whole thread Raw
In response to Idea: PostgreSQL equivalent to Oracle's KEEP clause  (Ben Clements <benhasgonewalking@gmail.com>)
Responses Re: Idea: PostgreSQL equivalent to Oracle's KEEP clause
List pgsql-general
Tree view 
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 by date:

Previous
From: Ben Clements
Date:
Subject: Idea: PostgreSQL equivalent to Oracle's KEEP clause
Next
From: Siddharth Jain
Date:
Subject: How does Postgres store a B-Tree on disk while using the OS file system?