Re: Fw: triggers

On Fri, Apr 16, 2004 at 10:17:16 -0300,
Iandé Coutinho <iande(at)br(dot)inter(dot)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(at)br(dot)inter(dot)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