BUG #15462: WITH ORDINALITY and CTEs don't work
От
PG Bug reporting form
Тема
BUG #15462: WITH ORDINALITY and CTEs don't work
Дата
Msg-id
15462-e08751fe7af734ac@postgresql.org
Список
Дерево обсуждения
BUG #15462: WITH ORDINALITY and CTEs don't work PG Bug reporting form <noreply@postgresql.org>
Re: BUG #15462: WITH ORDINALITY and CTEs don't work hubert depesz lubaczewski <depesz@depesz.com>
The following bug has been logged on the website: Bug reference: 15462 Logged by: Michael Meyer Email address: michael.meyer@pace.de PostgreSQL version: 11.0 Operating system: Windows 10 Description: CTEs don't play nicely together with 'WITH ORDINALITY': This is working: SELECT * FROM generate_series(4,1,-1) WITH ORDINALITY; WITH a AS (SELECT * FROM generate_series(4,1,-1) ) SELECT * FROM a; whereas this yields syntax error (42601) WITH a AS (SELECT * FROM generate_series(4,1,-1) ) SELECT * FROM a WITH ORDINALITY;
В списке pgsql-bugs по дате отправления
От: Tom Lane
Дата:
От: hubert depesz lubaczewski
Дата: