| From: | Onni Hakala <onni(at)keksi(dot)io> |
|---|---|
| To: | pgsql-novice(at)lists(dot)postgresql(dot)org |
| Subject: | How can I create a feature request for QUALIFY clause into PostgreSQL? |
| Date: | 2022-10-03 17:38:41 |
| Message-ID: | 6E722EEC-61FE-4EC0-B17D-B4468DA34BA1@keksi.io |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hey,
I was very happy learn about QUALIFY clause in BigQuery <https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#qualify_clause> 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 <https://wiki.postgresql.org/wiki/Todo>
Thanks in advance,
Onni Hakala
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2022-10-03 18:11:17 | Re: How can I create a feature request for QUALIFY clause into PostgreSQL? |
| Previous Message | David G. Johnston | 2022-09-07 16:31:11 | Re: restore overwrite? |