Re: Making the subquery alias optional in the FROM clause - Mailing list pgsql-hackers

From Dean Rasheed
Subject Re: Making the subquery alias optional in the FROM clause
Date
Msg-id CAEZATCWY670FpOF=63Wq5ZKYMbJNY-wK5CscdRxjtiqNT51tSw@mail.gmail.com
Whole thread Raw
In response to Re: Making the subquery alias optional in the FROM clause  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: Making the subquery alias optional in the FROM clause
Re: Making the subquery alias optional in the FROM clause
List pgsql-hackers
On Wed, 6 Jul 2022 at 15:09, Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
>
> I'll post an update in a little while, but first, I found a bug, which
> revealed a pre-existing bug in transformLockingClause(). I'll start a
> new thread for that, since it'd be good to get that resolved
> independently of this patch.
>

Attached is an update with the following changes:

* Docs updated as suggested.
* transformLockingClause() updated to skip subquery and values rtes
without aliases.
* eref->aliasname changed to "unnamed_subquery" for subqueries without aliases.

Regards,
Dean

Attachment

pgsql-hackers by date:

Previous
From: "Anton A. Melnikov"
Date:
Subject: Re: Possible fails in pg_stat_statements test
Next
From: Zhihong Yu
Date:
Subject: Re: Making the subquery alias optional in the FROM clause