Re: BUG #16435: regexp_split_to_table different behavior in 9.2 and 12.2

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #16435: regexp_split_to_table different behavior in 9.2 and 12.2
Дата
Msg-id CAKFQuwb+jdgntUDr9ogf4txOyAgmQ33BQxNjQ0RBW04X85dsrw@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #16435: regexp_split_to_table different behavior in 9.2 and 12.2  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #16435: regexp_split_to_table different behavior in 9.2 and12.2
Список pgsql-bugs
Дерево обсуждения
On Wed, May 13, 2020 at 12:14 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      16435
Logged by:          prashant
Email address:      prashant_rokad@yahoo.com
PostgreSQL version: 12.2
Operating system:   Windows
Description:       

Hi,

we are upgrading postgresql from 9.2 to 12.2 and observed that
"regexp_split_to_table" functions is giving different output in 12.2 than
9.2.

This was intentional.  You will need to rewrite your query - probably by moving the call to regexp_split_to_table to the FROM clause and leveraging the LATERAL feature. 

David J.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16435: regexp_split_to_table different behavior in 9.2 and 12.2
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16436: Functions with input parameter table type failing from application