I need some trigger help. I am very new to SQL, so please bare with me.
I have a table:
CREATE TABLE table (
Basically, I have values going into name.
The values that go into name are like this (being generated by a script),
without the quotes:
I want to write a trigger, for UPDATE/INSERT, do a ltrim and rtrim() of name
value. I want to remove all the beginning and ending blank spaces.
I want name to be like this:
Is that possible?
pgsql-novice by date
|Next:||From: Rodrigo De León||Date: 2007-11-20 16:19:09|
|Subject: Re: need trigger help|
|Previous:||From: Emil Oppeln-Bronikowski||Date: 2007-11-20 07:08:27|
|Subject: Re: Database version control|