pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: brichard@cafod.org.uk
To: pgsql-general@postgresql.org
Subject: Case sensitivity
Date: Tue, 27 Feb 2001 05:47:12 +0000
Message-ID: <20010227054712.A13552@usb.cafod.org.uk> (raw)

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



view thread (80+ messages)  latest in thread

Message-ID: <20010227054712.A13552@usb.cafod.org.uk>
Permalink:  ../20010227054712.A13552@usb.cafod.org.uk/
Also on:    postgresql.org/message-id/20010227054712.A13552@usb.cafod.org.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: brichard@cafod.org.uk
  Subject: Re: Case sensitivity
  In-Reply-To: <20010227054712.A13552@usb.cafod.org.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox