pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





view thread (7+ messages)  latest in thread

Message-ID: <5.1.0.14.0.20021120010436.00b4c920@192.168.1.3>
Permalink:  ../5.1.0.14.0.20021120010436.00b4c920@192.168.1.3/
Also on:    postgresql.org/message-id/5.1.0.14.0.20021120010436.00b4c920@192.168.1.3

 · 

reply

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