Oleg,
This looks like a great module, do you have a pointer to it in English?
If can send this module to me as a compressed file, I'll take the time
to post it on PgFoundry as a new project that everyone can easily
access and download.
Paul- if you go with the lower() edits route, be sure to note Joshua's
coment on the funcional index- one of the best, unknown features in
PG.
On 4/3/07, Oleg Bartunov <oleg@sai.msu.su> wrote:
> Paul,
>
> we have contrib module mchar, which does what you need. We developed it
> when porting from MS SQL one very popular in Russia accounting software.
> It's available from http://v8.1c.ru/overview/postgres_patches_notes.htm,
> in Russian. I don't rememeber about license, though.
>
>
> Oleg
>
> On Wed, 4 Apr 2007, Paul Lambert wrote:
>
> > Joshua D. Drake wrote:
> >
> >>
> >> 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
> >>
> >>
> >
> > I'm trying to avoid having to alter all of my queries, per the OP I've got
> > several hundred if not thousands of them and if I have to change them all to
> > put lower() around all the text, that is a lot of time.
> >
> > If I have to do that I will, I'm just curious if there was an ability to tell
> > pg to not be case sensitive when doing lookups.
> >
> > Judging by the responses so far, there is not... so I'll get to work :)
> >
> >
>
> Regards,
> Oleg
> _____________________________________________________________
> Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
> Sternberg Astronomical Institute, Moscow University, Russia
> Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
> phone: +007(495)939-16-83, +007(495)939-23-83
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
