Search Postgresql Archives

Re: Using MS Access front-end with PG]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxx> 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@xxxxxxxxxx, 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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux