Re[2]: [GENERAL] case-insensitive like operator

From: yura <yura(at)vpcit(dot)ru>
To: pgsql-general <pgsql-general(at)postgreSQL(dot)org>
Subject: Re[2]: [GENERAL] case-insensitive like operator
Date: 2000-01-15 11:49:09
Message-ID: 15700.000115@vpcit.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Shadkam,

Wednesday, January 12, 2000, 4:41:20 PM, you wrote:

SI> Hi Yury,

SI> I do not know the most correct solution but I used a work around while
SI> encountering a similar problem

SI> select * from table_name
SI> where upper (field_name) like 'SOME_THING_IN_UPPERCASE'

SI> Hope it helps.

SI> - Cheers
SI> - Shad.

SI> + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
SI> | Each human owes infinitely more to the human race than to the |
SI> | particular country in which he was born. -- Francois Fenelon |
SI> + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +

SI> On Sat, 15 Jan 2000, yura wrote:

>> Hello All,
>>
>> I have a following problem:
>>
>> We have ported MS Acess database to PostgreSQL. Everything ok, but our
>> user are used to search data in tables using filters, and Access does
>> case insensitive search, but when working with Postgres database it
>> converts filters into queries with 'like' operator. So is there any
>> way to make 'like' operator case insensitive? Or maybe somebody has
>> the same problems and knows the solution?
>>
>> Best regards,
>> Yury mailto:yura(at)vpcit(dot)ru
>>
>>
>>
>> ************
>>

Unfortunately, MS Access converts filters into queries
select ... from <tab> where <fieldname> like <text>

Best regards,
yura mailto:yura(at)vpcit(dot)ru

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ed Loehr 2000-01-15 16:48:41 Re: [GENERAL] keeping track of date
Previous Message yura 2000-01-15 11:28:11 Re[2]: [GENERAL] case-insensitive like operator