Skip site navigation (1) Skip section navigation (2)

Re: Using MS Access front-end with PG]

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Using MS Access front-end with PG]
Date: 2007-04-04 01:24:00
Message-ID: 4612FE30.1090601@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
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/


In response to

Responses

pgsql-hackers by date

Next:From: Edward MacnaghtenDate: 2007-04-04 01:50:51
Subject: Re: Using MS Access front-end with PG]
Previous:From: Paul LambertDate: 2007-04-04 00:41:36
Subject: Re: Using MS Access front-end with PG]

pgsql-general by date

Next:From: Edward MacnaghtenDate: 2007-04-04 01:48:22
Subject: Re: Using MS Access front-end with PG
Previous:From: Joshua D. DrakeDate: 2007-04-04 01:22:33
Subject: Re: Using MS Access front-end with PG

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group