Re: PGSQL 10.9 vs PGSQL 9.6 SQL query behaviour.
Jeff Janes <[email protected]> Tue, 22 Oct 2019 12:27:52 -0400
| Newsgroups | gmane.comp.db.postgresql.admin |
|---|---|
| Message-ID | <CAMkU=1zJS6kwYcF92f=e2uE8Fwmu1pyj=5i_nfzQD9ZT991kUg@mail.gmail.com> |
On Tue, Oct 22, 2019 at 12:08 PM Ghiurea, Isabella < [email protected]> 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 >