Re: Using MS Access front-end with PG]

Paul Lambert wrote:
>
>
> Tom Lane wrote:
>> Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au> writes:
>>> Is there any way to change the text qualifier in PG
>>
>> No. I suppose you could hack the Postgres lexer but you'd break
>> pretty much absolutely everything other than your Access code.
>>
>>> or the case sensitivity?
>>
>> That could be attacked in a few ways, depending on whether you want
>> all text comparisons to be case-insensitive or only some (and if so
>> which "some"). But it sounds like MS SQL's backward standards for
>> strings vs identifiers has got you nicely locked in, as intended :-(
>> so there may be no point in discussing further.
>
> I don't have any case sensitive data - so if sensitivity could be
> completely disabled by a parameter somewhere, that would be nice.

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

>
>>
>> regards, tom lane
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 2: Don't 'kill -9' the postmaster
>>
>>
>
>

--

=== 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/