Received: from ara.zf.jcu.cz (ara.zf.jcu.cz [160.217.161.4]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4FDm2A00679 for ; Tue, 15 May 2001 09:48:02 -0400 (EDT) (envelope-from zakkr@zf.jcu.cz) Received: (from zakkr@localhost) by ara.zf.jcu.cz (8.9.3/8.9.3/Debian 8.9.3-21) id PAA02399; Tue, 15 May 2001 15:47:57 +0200 Date: Tue, 15 May 2001 15:47:57 +0200 From: Karel Zak To: =?iso-8859-2?Q?Borek_Lupom=ECsk=FD?= Cc: pgsql-sql@postgresql.org Subject: Re: Case insensitive string comparison? Message-ID: <20010515154756.A24706@ara.zf.jcu.cz> References: Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.0.1i In-Reply-To: ; from borekl@volny.cz on Tue, May 15, 2001 at 02:48:24PM +0200 X-Archive-Number: 200105/146 X-Sequence-Number: 2963 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 http://home.zf.jcu.cz/~zakkr/ C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz