Re: Using MS Access front-end with PG]

Edward Macnaghten wrote:
> 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.

You could use a functional index to solve that.

CREATE INDEX lower_bar_idx on foo(lower(bar));

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

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/