On Tue, 03 Apr 2007 18:24:00 -0700, "Joshua D. Drake" <jd@commandprompt.com> wrote:
> Paul Lambert wrote:
> > Tom Lane wrote:
> >> Paul Lambert <paul.lambert@autoledgers.com.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@kgb.une.edu.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 : :
+---------------------------------------+-----------------+

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend