From: Michiel Lange <michiel@minas.demon.nl>
To: pgsql-sql@postgresql.org
Subject: trying to learn plpqsql... so please forgive..
Date: Wed, 20 Nov 2002 01:16:12 +0100
Message-ID: <5.1.0.14.0.20021120010436.00b4c920@192.168.1.3> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: michiel@minas.demon.nl
Subject: Re: trying to learn plpqsql... so please forgive..
In-Reply-To: <5.1.0.14.0.20021120010436.00b4c920@192.168.1.3>
References: <5.1.0.14.0.20021120010436.00b4c920@192.168.1.3>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox