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