Re: Different behavior between v15 and v17 using WITH CTE - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: Different behavior between v15 and v17 using WITH CTE
Date
Msg-id CAKFQuwZ2n-MX+P-hk-5gX2PrpbB9BwYBFr81oQVn3FUm_h=kfA@mail.gmail.com
Whole thread Raw
Responses Re: Different behavior between v15 and v17 using WITH CTE
List pgsql-bugs
On Wednesday, May 7, 2025, marcos sicat <marcos.sicat@atlasifs.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.
 

pgsql-bugs by date:

Previous
From: Devrim Gündüz
Date:
Subject: Re: BUG #18915: pgdg-redhat-repo-42.0-51PGDG.noarch package not available in postgres repo
Next
From: marcos sicat
Date:
Subject: Re: Different behavior between v15 and v17 using WITH CTE