Case insensitive string comparison?

From: Borek Lupoměský <borekl(at)volny(dot)cz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Case insensitive string comparison?
Date: 2001-05-15 12:48:24
Message-ID: Pine.LNX.4.21.0105151445270.29217-100000@diaspar.ujep.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Is there an operator for case insensitive string comparison, or
should I use regular expression matching with ~* '^string$'?

Bye Borek

- --

=====================================================================
BOREK LUPOMESKY Usti nad Labem, Czech Republic, Europe
WWW: http://www.volny.cz/borekl/ PGP keyid: B6A06AEB
==========[ MIME/ISO-8859-2 & PGP encrypted mail welcome ]===========

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.1 (GNU/Linux)
Comment: Get GPG key at http://www.volny.cz/borekl/pgp.txt

iD8DBQE7ASWbA6dWI7agausRAj4JAKCk5MCYlsLEjf+IR5ZZfy6ypDNG7QCeJj2n
eyPHuxTW+WQGyeo4SuvZvsw=
=p+pz
-----END PGP SIGNATURE-----

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Guru Prasad 2001-05-15 13:10:49 Re: working with stored procedures (fwd)
Previous Message Justin Clift 2001-05-15 10:57:57 Re: system time