Postgres Pro
Downloads
Home   >   mailing lists

How can I create a feature request for QUALIFY clause into PostgreSQL? - Mailing list pgsql-novice

From Onni Hakala
Subject How can I create a feature request for QUALIFY clause into PostgreSQL?
Date
Msg-id 6E722EEC-61FE-4EC0-B17D-B4468DA34BA1@keksi.io
Whole thread Raw
Responses Re: How can I create a feature request for QUALIFY clause into PostgreSQL?  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-novice
Tree view
Hey,

I was very happy learn about QUALIFY clause in BigQuery today.

I have used window functions usually with subqueries like this:
SELECT * FROM (  SELECT    *,    ROW_NUMBER OVER (PARTITION BY something ORDER BY modified_date DESC) AS row_number  FROM table_name
)
WHERE row_number = 1

With QUALIFY it's much more ergonomic and cleaner to do the same thing.
SELECT *
FROM table_name
QUALIFY ROW_NUMBER() OVER (PARTITION BY something ORDER BY modified_date DESC) = 1

QUALIFY is also better since it doesn't include extra column row_number to the result.

Where should I send message so that Postgres maintainers would consider adding this into the TODO page: https://wiki.postgresql.org/wiki/Todo

Thanks in advance,
Onni Hakala

pgsql-novice by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: restore overwrite?
Next
From: Laurenz Albe
Date:
Subject: Re: How can I create a feature request for QUALIFY clause into PostgreSQL?