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 : :
+---------------------------------------+-----------------+
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] |
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] |