Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #16435: regexp_split_to_table different behavior in 9.2 and12.2 - Mailing list pgsql-bugs

From prashant rokad
Subject Re: BUG #16435: regexp_split_to_table different behavior in 9.2 and12.2
Date
Msg-id 133391319.742712.1589547389739@mail.yahoo.com
Whole thread Raw
In response to Re: BUG #16435: regexp_split_to_table different behavior in 9.2 and 12.2  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view
Thank you so much for your reply. I will follow the same.

Regards,
Prashant


On Thu, 14 May 2020 at 2:47 am, David G. Johnston
<david.g.johnston@gmail.com> wrote:
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 by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: BUG #16439: can not read table info for greenplum 6
Next
From: David Gilman
Date:
Subject: Re: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -hlocalhost --jobs=2 crashes