Re: Proposal: QUALIFY clause
| От | Marcos Pegoraro |
|---|---|
| Тема | Re: Proposal: QUALIFY clause |
| Дата | |
| Msg-id | CAB-JLwboVrNVRPD4CC1bJhgJQB50wcUn-NWkfgEpfXsmby1spg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Proposal: QUALIFY clause ("Matheus Alcantara" <matheusssilv97@gmail.com>) |
| Ответы |
Re: Proposal: QUALIFY clause
|
| Список | pgsql-hackers |
Em ter., 22 de jul. de 2025 às 08:56, Matheus Alcantara <matheusssilv97@gmail.com> escreveu:
The current patch supports the following syntaxes:
SELECT a, b, c
wf() OVER () as d
FROM tab
QUALIFY d = 1
When using the "QUALIFY d = 1" form, I currently rewrite the expression
as "wf() OVER () = 1" by searching the targetlist for the matching
alias, replacing the Var with the corresponding WindowFunc.
Not related to $subject but that way you did,
that replacement alias for wf expression, is cool.
With that would it be possible to have where replacements too ? Maybe.
select a+b as ab from t where ab = 5
regards
Marcos
В списке pgsql-hackers по дате отправления: