2011/11/6 Andrus <kobrule...@hot.ee>: > 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?
A simple trigger like this should work fine. You're basically throwing an upper() around the field in a function and calling that a trigger. If you decided to do it in the application, then throwing a constraint around each updated / inserted text col is pretty easy too. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
