Re: [GENERAL] Using MS Access front-end with PG]

[Edward Macnaghten]

Joshua D. Drake wrote:
You could preface all your queries with something like:
select * from foo where lower(bar) = lower('qualifer');

But that seems a bit silly.


And also it would prevent the optimizer from using any indexes on 
"bar".  Not a good idea.

Eddy


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend