Re: Different behavior between v15 and v17 using WITH CTE

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: marcos sicat <marcos(dot)sicat(at)atlasifs(dot)com>
Cc: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Different behavior between v15 and v17 using WITH CTE
Date: 2025-05-07 19:03:12
Message-ID: CAKFQuwZ2n-MX+P-hk-5gX2PrpbB9BwYBFr81oQVn3FUm_h=kfA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wednesday, May 7, 2025, marcos sicat <marcos(dot)sicat(at)atlasifs(dot)com> wrote:

> I am running this query on v17 and generating the results, but not on v15.
>
> In v15:
>
> [Code: 0, SQL State: 42601] ERROR: subquery in FROM must have an alias
> Hint: For example, FROM (SELECT ...) [AS] foo.
> Position: 39 [Script position: 38 - 45]
>

Yes, we’ve since removed the requirement to assign the alias. If you need
to run the query in v15 you will need to provide one.

David J.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message marcos sicat 2025-05-07 19:07:54 Re: Different behavior between v15 and v17 using WITH CTE
Previous Message marcos sicat 2025-05-07 18:58:59 Different behavior between v15 and v17 using WITH CTE