Postgres Pro
Downloads
Home   >   mailing lists

Re: PGSQL 10.9 vs PGSQL 9.6 SQL query behaviour. - Mailing list pgsql-admin

From Jeff Janes
Subject Re: PGSQL 10.9 vs PGSQL 9.6 SQL query behaviour.
Date
Msg-id CAMkU=1zJS6kwYcF92f=e2uE8Fwmu1pyj=5i_nfzQD9ZT991kUg@mail.gmail.com
Whole thread Raw
In response to Re: PGSQL 10.9 vs PGSQL 9.6 SQL query behaviour.  ("Ghiurea, Isabella" <Isabella.Ghiurea@nrc-cnrc.gc.ca>)
List pgsql-admin
Tree view
On Tue, Oct 22, 2019 at 12:08 PM Ghiurea, Isabella <Isabella.Ghiurea@nrc-cnrc.gc.ca> wrote:

Hi  Jeff,

Thank you for suggestion, yes we tested without Pgsphere index ( dropped the index) in PGSQL 10.9 , run same SQL and got the expected result which is same as the one in PG 9.5 but different f when using the PG sphere in 10.9( which returned null rows),


If you recreate the index, is it still broken or does it work properly?
 
Cheers,

Jeff

pgsql-admin by date:

Previous
From: "Ghiurea, Isabella"
Date:
Subject: Re: PGSQL 10.9 vs PGSQL 9.6 SQL query behaviour.
Next
From: Karl Denninger
Date:
Subject: Upgrade failure attempting to go to 12.0