Received: from usb.cafod.org.uk (workstation149.cafod.org.uk [195.172.69.149]
	(may be forged))
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1R5ibx78756
	for <pgsql-general@postgresql.org>;
	Tue, 27 Feb 2001 00:44:37 -0500 (EST)
	(envelope-from brichard@cafod.org.uk)
Received: by usb.cafod.org.uk (Postfix, from userid 1000)
	id 5C9E02892; Tue, 27 Feb 2001 05:47:12 +0000 (GMT)
Date: Tue, 27 Feb 2001 05:47:12 +0000
To: pgsql-general@postgresql.org
Subject: Case sensitivity
Message-ID: <20010227054712.A13552@usb.cafod.org.uk>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2.5i
From: brichard@cafod.org.uk (Bruce Richardson)
X-Archive-Number: 200102/1324
X-Sequence-Number: 5283

Discovering that text fields in Postgres are case sensitive - so "Text"
<> "text" and both can go into the same UNIQUE column - threw me a bit,
as this is different from other databases I've worked with.

Is there a toggle to turn off case sensitivity, either for a whole
database or for a column?  Or do I just have to get used to ~*?

-- 
Bruce