Re: Proposal: QUALIFY clause - Mailing list pgsql-hackers

From Vik Fearing
Subject Re: Proposal: QUALIFY clause
Date
Msg-id c5e9fe6e-0f93-4933-97f1-85a0acc774be@postgresfriends.org
Whole thread Raw
In response to Re: Proposal: QUALIFY clause  ("Matheus Alcantara" <matheusssilv97@gmail.com>)
Responses Re: Proposal: QUALIFY clause
List 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




pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: index prefetching
Next
From: Dmitry Mityugov
Date:
Subject: Re: [PATCH] Use strchr() to search for a single character