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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ben Clements <benhasgonewalking(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Idea: PostgreSQL equivalent to Oracle's KEEP clause
Date: 2023-03-06 23:40:43
Message-ID: 3766373.1678146043@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ben Clements <benhasgonewalking(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Siddharth Jain 2023-03-07 00:24:56 How does Postgres store a B-Tree on disk while using the OS file system?
Previous Message Ben Clements 2023-03-06 22:06:27 Idea: PostgreSQL equivalent to Oracle's KEEP clause