Henning Garus writes:
> However when the String is cast to text the index isn't used:
> explain select * from test where id = 'foo'::text;
That's because "text" is considered a preferred type, so it wins
the contest over whether '=' means texteq or bpchareq:
# explain select * from test where id
On 2/4/25 08:23, Henning Garus wrote:
Hi,
I stumbled upon this behaviour when digging into the performance of some
merge statements generated by hibernate.
Looking at different String types (varchar, text and bpchar) in some
cases an index is used when the index type differs from the type in
Hi,
I stumbled upon this behaviour when digging into the performance of some
merge statements generated by hibernate.
Looking at different String types (varchar, text and bpchar) in some cases
an index is used when the index type differs from the type in the query, in
some cases it isn't used.
G
