What is the best way to force character data to upper case

From: "Dennis" <dennis(at)kabonkulator(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: What is the best way to force character data to upper case
Date: 2012-02-02 06:09:08
Message-ID: 005001cce171$2ccae430$8660ac90$@kabonkulator.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am wondering what the best way is to force character data to a specific
case, like upper case for example. Is a trigger or rule the only option?
Would a check constraint be better or faster than using rules or triggers,
knowing that a check constraint puts the onus back on the client code to
ensure the data is in the correct case?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Venkat Balaji 2012-02-02 06:51:44 [GENERA]: Postgresql-9.1.1 synchronous replication issue
Previous Message Christopher Opena 2012-02-02 05:56:16 Re: Puzzling full database lock