X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id E3D539FB267
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 11 Sep 2006 16:09:25 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 20353-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 11 Sep 2006 16:09:17 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168])
	by postgresql.org (Postfix) with ESMTP id 93B2E9FA304
	for <pgsql-sql@postgresql.org>; Mon, 11 Sep 2006 16:09:17 -0300 (ADT)
Received: by ug-out-1314.google.com with SMTP id m3so1311292ugc
	for <pgsql-sql@postgresql.org>; Mon, 11 Sep 2006 12:09:15 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
	b=uQgPweJ6P4TmlMNrypsTDgDCIuTChqECMoO5Aw6qDIJNrJlO7n47d5fh0jvL7/UKcVVJIGPSqIPDdbIDUvCpGzRtymCe7Z6SXg59cGRBKhjGkNOJ6L1broxpab1SWQ70enKY5RRUR+NNaCZPAOO/Yg4UYR0jwGiyCEs/a/BUhyw=
Received: by 10.67.21.11 with SMTP id y11mr2968902ugi;
	Mon, 11 Sep 2006 12:09:14 -0700 (PDT)
Received: by 10.67.102.14 with HTTP; Mon, 11 Sep 2006 12:09:14 -0700 (PDT)
Message-ID: <6b4c32560609111209v7edc95dcq9a559d0f5e69027b@mail.gmail.com>
Date: Mon, 11 Sep 2006 21:09:14 +0200
From: "=?ISO-8859-1?Q?Ragnar_=D6sterlund?=" <ragoster@gmail.com>
To: pgsql-sql@postgresql.org
Subject: case insensitive regex clause with some latin1 characters fails
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.199 tagged_above=0 required=5
	tests=DNS_FROM_RFC_ABUSE, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200609/70
X-Sequence-Number: 26281

Hi,

I'm not sure if this is a bug or if I'm doing something wrong. I have
a database encoded with ISO-8859-1, aka LATIN1. When I do something
like:

SELECT '=C4' ~* '=E4';

it returns false. If i do:

SELECT 'A' ~* 'a';

I get true. According to specification, both should return true.
Anyone knows what the problem might be?

/Ragnar