On Fri, Apr 16, 2004 at 10:17:16 -0300,
Iandé Coutinho <iande@br.inter.net> wrote:
> Anyone??
A simple way to do this would be to create a view with the calculated column.
> ----- Original Message -----
> From: "Iandé Coutinho" <iande@br.inter.net>
> To: <pgsql-novice@postgresql.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@postgresql.org)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster