Re: Using MS Access front-end with PG]

Поиск
Список
Период
Сортировка
От Paul Lambert
Тема Re: Using MS Access front-end with PG]
Дата
Msg-id 461314DD.5080009@autoledgers.com.au
обсуждение исходный текст
Ответ на Re: Using MS Access front-end with PG]  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: Using MS Access front-end with PG]
Список pgsql-general
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.
>
> Joshua D. Drake
>
>

I'm trying to avoid having to alter all of my queries, per the OP I've
got several hundred if not thousands of them and if I have to change
them all to put lower() around all the text, that is a lot of time.

If I have to do that I will, I'm just curious if there was an ability to
tell pg to not be case sensitive when doing lookups.

Judging by the responses so far, there is not... so I'll get to work :)

--
Paul Lambert
Database Administrator
AutoLedgers

В списке pgsql-general по дате отправления:

Предыдущее
От: Klint Gore
Дата:
Сообщение: Re: Using MS Access front-end with PG]
Следующее
От: Paul Lambert
Дата:
Сообщение: Re: Using MS Access front-end with PG