Re: Case insensitive string comparison?

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Borek Lupoměský <borekl(at)volny(dot)cz>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Case insensitive string comparison?
Date: 2001-05-15 13:47:57
Message-ID: 20010515154756.A24706@ara.zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, May 15, 2001 at 02:48:24PM +0200, Borek Lupoměský wrote:
> Is there an operator for case insensitive string comparison, or
> should I use regular expression matching with ~* '^string$'?

possibility:

- use upper() / lower() inside query

- regex operators: ~* or !~*

- case insensitive 'like'

Karel

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-05-15 14:12:42 Re: How NULL is interpreted in Pgsql
Previous Message Guru Prasad 2001-05-15 13:10:49 Re: working with stored procedures (fwd)