From: | Iandé Coutinho <iande(at)br(dot)inter(dot)net> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | triggers |
Date: | 2004-04-15 18:49:57 |
Message-ID: | 001f01c4231a$850cffc0$9a01a8c0@providerst.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Afternoon guys, I would be very gratefull if anyone could help me on this
one. I´ve tried looking for examples on it, i know it´s simple, but i can´t
get one, so here goes. I need to create a trigger(after insert), preferebly
in plpgsql, as I have already created the lang using createlang, that, takes
value from 2 columns of the record it´s inserting, and concatenate together
and insert it into a 3rd column,
for example:
I have a table:
employee
id | branch | name | uniqueId
---|--------|-------|---------
on insert into employee(id,branch,name) values(1,1543,"iande");
the trigger would get both id and branch valeus and insert on uniqueId
so,
select * from employee;
id | branch | name | uniqueId
-----------------------------
1 | 1543 | iande | 15431
thanks in advance;
Iandé
From | Date | Subject | |
---|---|---|---|
Next Message | Michal Lijowski | 2004-04-15 19:03:03 | Using SELECT WHERE |
Previous Message | Tom Lane | 2004-04-15 13:06:09 | Re: any signed decimal data type? |