PostgreSQL index with lower

BIZ TMS Aurelius
1

HI,
Porting to postgreSQL
We have a lot of varchar index fields , which are defined
CREATE INDEX "something-key2"
ON Table1( lower (name));
and they need to be searched like where lower(name)=:p1
can I somehow add lower to search without using linq.sql .

I mean that old delphi code om.find.where(dic.something.name=aname) would generate
sql ... where lower(A.name) = :p1

2

Unfortunately there isn't something builtin to do that automatically. You will have indeed to modify the Linq queries.

3

noticed of course that dic.something.name.lower works of course.

1 Like
4

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.