How to force some char type columns to be stored in uppercase

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to force some char type columns to be stored in uppercase
Date: 2011-11-06 19:58:56
Message-ID: 58B7004F635A43F5B4942567CD6A8378@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

in 8.1+ many char(n) type columns must be in uppercase in database.
What is best way to force this ?

Should insert and update triggers created for every table or is there better
way,
for example by creation domain or adding some attribute to column and
creating global trigger?

Andrus

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cstdenis 2011-11-06 20:15:09 Re: Distinct on a non-sort column
Previous Message John R Pierce 2011-11-06 19:00:08 Re: Tuning PostgreSQL for very large database