need trigger help

["Mag Gam" <magawake(at)gmail(dot)com>]

Hi All,

I need some trigger help. I am very new to SQL, so please bare with me.

I have a table:

CREATE TABLE table (
    id integer,
    name text,
);

Basically, I have values going into name.

The values that go into name are like this (being generated by a script), without the quotes:
"    name1"
"name2"
"  name3"
"    name4"
"name5   "

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:
"name1"
"name2"
"name3"
"name4"
"name5"


Is that possible?

TIA