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

Поиск
Список
Период
Сортировка
От Michiel Lange
Тема trying to learn plpqsql... so please forgive..
Дата
Msg-id 5.1.0.14.0.20021120010436.00b4c920@192.168.1.3
обсуждение исходный текст
Ответы Re: trying to learn plpqsql... so please forgive..  ("Josh Berkus" <josh@agliodbs.com>)
Список 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




В списке pgsql-sql по дате отправления:

Предыдущее
От: Chris Gamache
Дата:
Сообщение: Re: Using VIEW to simplify code...
Следующее
От: Hugh Esco
Дата:
Сообщение: Re: Problems invoking psql. Help please.