trying to learn plpqsql... so please forgive..

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

Responses

Browse pgsql-sql by date

  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...