On Wed, Apr 26, 2006 at 12:52:55 -0700,
Leonardo Boiko <leoboiko(at)gmail(dot)com> wrote:
> Suppose I have a bunch of fields in different tables which I'd like to
> always force to lowercase (since they represent case-insensitive data).
> Suppose I want to do it at SQL level, not application level. If the
> user say "INSERT INTO foo VALUES ('Abc')", I want to really insert
> 'abc'. Is there an elegant way of doing this? Some kind of trigger,
> maybe? I have no experience with triggers or pl/sql, but I couldn't
> come up with a solution general enough to be reused in multiple places.
> Or is the premise a bad idea?
You can use a before trigger to change the value of the column when it
is inserted or updated.
In response to
pgsql-novice by date
|Next:||From: operationsengineer1||Date: 2006-04-29 21:33:01|
|Subject: PGAdmin3 Permisions|
|Previous:||From: Andreas Kretschmer||Date: 2006-04-29 20:19:18|
|Subject: Re: running pg_dumpall as a cron job|