Postgres Pro
Downloads
Home   >   mailing lists

Re: Case insensitive string comparison? - Mailing list pgsql-sql

From Karel Zak
Subject Re: Case insensitive string comparison?
Date
Msg-id 20010515154756.A24706@ara.zf.jcu.cz
Whole thread Raw
In response to Case insensitive string comparison?  (Borek Lupoměský <borekl@volny.cz>)
Responses Re: Case insensitive string comparison?
List pgsql-sql
Tree view 
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@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/C, PostgreSQL, PHP, WWW, http://docs.linux.cz,
http://mape.jcu.cz

pgsql-sql by date:

Previous
From: Guru Prasad
Date:
Subject: Re: working with stored procedures (fwd)
Next
From: Tom Lane
Date:
Subject: Re: How NULL is interpreted in Pgsql