From: | Michiel Lange <michiel(at)minas(dot)demon(dot)nl> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | trying to learn plpqsql... so please forgive.. |
Date: | 2002-11-20 00:16:12 |
Message-ID: | 5.1.0.14.0.20021120010436.00b4c920@192.168.1.3 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Maybe this should be sent to novice... I was not certain, but if it should,
please tell me so.
The matter at hand is this:
When I do an 'INSERT INTO <table> VALUES <row1,row2,row3>'
and on the table is a serial primary key named p_key.
As I want this number to be auto-generated, but use it as a 'customer
number', I want to create this function to return the value of this insert.
I thought/hoped that this would work, but as there are some people
dependant on this database, I dare not try out too much ;-) This would be
the first time I used plpgsql, so I am not so certain about what I do.
CREATE FUNCTION add_cust() RETURNS INT4 AS ' -- SERIAL data type is really
an INT4 (and some more).
BEGIN
RETURN NEW.p_key;
END;
' LANGUAGE 'plpgsql';
CREATE TRIGGER add_cust BEFORE INSERT ON table
FOR EACH ROW EXECUTE PROCEDURE add_cust();
Someone willing to evaluate this for me, and telling me if it is safe to
use as it is? or things I may do wrong?
TIA,
Michiel
From | Date | Subject | |
---|---|---|---|
Next Message | jasiek | 2002-11-20 00:30:12 | Re: Problems invoking psql. Help please. |
Previous Message | Chris Gamache | 2002-11-19 23:40:35 | Re: Using VIEW to simplify code... |