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
обсуждение исходный текст
Ответы Re: BUG #15462: WITH ORDINALITY and CTEs don't work  (hubert depesz lubaczewski <depesz@depesz.com>)
Список pgsql-bugs
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
Дата:
Сообщение: Re: BUG #15461: Postgresql fuzzy match extension giving out error
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: BUG #15462: WITH ORDINALITY and CTEs don't work