Skip site navigation (1) Skip section navigation (2)

Re: triggers

From: Iandé Coutinho <iande(at)br(dot)inter(dot)net>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: triggers
Date: 2004-04-16 14:22:26
Message-ID: 008f01c423be$500882f0$9a01a8c0@providerst.local (view raw or flat)
Thread:
Lists: pgsql-novice
thanks Colin, that worked just great!! :)

----- Original Message ----- 
From: "Colin Gillespie" <C(dot)Gillespie(at)newcastle(dot)ac(dot)uk>
To: "Iandé Coutinho" <iande(at)br(dot)inter(dot)net>; <pgsql-novice(at)postgresql(dot)org>
Sent: Friday, April 16, 2004 10:51 AM
Subject: RE: [NOVICE] triggers


Hi Iande,

Try this

DROP TABLE t1 CASCADE;
CREATE TABLE t1
(
id serial,
branch integer NOT NULL,
uniqueid integer
);

DROP FUNCTION insert_uniqueid();
CREATE FUNCTION insert_uniqueid() RETURNS trigger AS'
BEGIN
NEW.uniqueid:= NEW.id||NEW.branch;
RETURN NEW;
END;
' LANGUAGE 'plpgsql';

CREATE TRIGGER insert_uniqueid BEFORE INSERT
ON t1 FOR EACH ROW EXECUTE
PROCEDURE insert_uniqueid();

Colin


-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org on behalf of Iandé Coutinho
Sent: Fri 4/16/2004 2:17 PM
To: pgsql-novice(at)postgresql(dot)org
Subject: Fw: [NOVICE] triggers

Anyone??
----- 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




In response to

pgsql-novice by date

Next:From: Bruno Wolff IIIDate: 2004-04-16 14:26:43
Subject: Re: Fw: triggers
Previous:From: Colin GillespieDate: 2004-04-16 13:51:57
Subject: Re: triggers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group