Re: Proposal: QUALIFY clause

From: Vik Fearing <vik(at)postgresfriends(dot)org>
To: Matheus Alcantara <matheusssilv97(at)gmail(dot)com>, Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Peter Eisentraut <peter(at)eisentraut(dot)org>
Subject: Re: Proposal: QUALIFY clause
Date: 2025-07-22 21:21:22
Message-ID: c5e9fe6e-0f93-4933-97f1-85a0acc774be@postgresfriends.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On 22/07/2025 20:54, Matheus Alcantara wrote:
> (this happens on transformQualifyClause() if you want to take a look)

I took a quick look at the patch (without applying and testing it) and
it seems to me that parse analysis is the wrong place to do this. We
want ruleutils to be able to spew out the QUALIFY clause as written in a
view and not as transformed.  If we are going to go down the syntax
transformation route, that should happen in the rewriter at
planning/execution time.

--

Vik Fearing

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dmitry Mityugov 2025-07-22 21:34:05 Re: [PATCH] Use strchr() to search for a single character
Previous Message Andres Freund 2025-07-22 21:11:04 Re: index prefetching