Horton
Menu

Re: Different behavior between v15 and v17 using WITH CTE

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: marcos sicat <marcos.sicat@atlasifs.com>
Cc: "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2025-05-07T19:03:12Z
Lists: 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.