On 3/21/24 18:25, John Burns wrote:
> Hi…
>
> ...
>
> Although the postcode package is probably not especially significant
> in the scheme of things , the behaviour of indexed versus non-indexed
> queries is worrisome.
>
Seems like a thinko in the indexing, but that's just a guess.
> I’ve had to make a couple of minor changes to the postcode package
> as the Postgres versions have changed, i.e. define TRUE and FALSE in
> the c header files and change the location of the include files when
> Postgres 16 arrived, but nothing else.
Can you share a patch with the tweaks?
>
> I’ve attached a sample data file to populate a table that exhibits
> the behaviour, and the tweaked version of the Postcode package.
>
I don't see any attachments :-(
regards
--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company