Anyone??
----- Original Message -----
From: "Iandé Coutinho" <iande (AT) br (DOT) inter.net>
To: <pgsql-novice (AT) postgresql (DOT) org>
Sent: Thursday, April 15, 2004 3:49 PM
Subject: [NOVICE] triggers


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é






---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

On Fri, Apr 16, 2004 at 10:17:16 -0300,
Iandé Coutinho <iande (AT) br (DOT) inter.net> wrote:
A simple way to do this would be to create a view with the calculated column.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend