Re: Using MS Access front-end with PG]

From: Klint Gore <kg(at)kgb(dot)une(dot)edu(dot)au>
To: Joshua D(dot)Drake <jd(at)commandprompt(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>
Subject: Re: Using MS Access front-end with PG]
Date: 2007-04-04 03:02:24
Message-ID: 461315401E7.FDAEKG@129.180.47.120
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Tue, 03 Apr 2007 18:24:00 -0700, "Joshua D. Drake" <jd(at)commandprompt(dot)com> wrote:
> Paul Lambert wrote:
> > Tom Lane wrote:
> >> Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au> writes:
> >>> 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.

Is there any way to create operators to point like to ilike? There
doesn't seem to be a like or ilike in pg_operator (not in 7.4 anyway).

klint.

+---------------------------------------+-----------------+
: Klint Gore : "Non rhyming :
: EMail : kg(at)kgb(dot)une(dot)edu(dot)au : slang - the :
: Snail : A.B.R.I. : possibilities :
: Mail University of New England : are useless" :
: Armidale NSW 2351 Australia : L.J.J. :
: Fax : +61 2 6772 5376 : :
+---------------------------------------+-----------------+

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Lambert 2007-04-04 03:03:53 Re: Using MS Access front-end with PG
Previous Message Paul Lambert 2007-04-04 03:00:45 Re: Using MS Access front-end with PG]

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-04-04 03:20:07 Re: Using MS Access front-end with PG]
Previous Message Paul Lambert 2007-04-04 03:00:45 Re: Using MS Access front-end with PG]