From: | Renaud Tthonnart <thonnart(at)amwdb(dot)u-strasbg(dot)fr> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: sequence and stored procedure |
Date: | 2001-02-22 08:20:19 |
Message-ID: | 3A94CBC3.533E8B09@amwdb.u-strasbg.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Stephan Szabo wrote:
> On Wed, 21 Feb 2001, Renaud Tthonnart wrote:
>
> > How can I use sequences in a stored procedure written with pl/pgsql?
>
> What exactly are you trying to do? Pretty much you can call the
> sequence functions you want to use on the sequence name you
> want (you have to double the quotes around the name since it's
> inside the quoted text of the function.
>
> create function foo() returns opaque as
> '
> begin
> NEW.y:=nextval(''seqseq'');
> return NEW;
> end;' language 'plpgsql';
>
> create trigger footrig before insert or update on testfoo for
> each row execute procedure foo();
Thank for your answer! That will help me !
Renaud THONNART
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Sawtell | 2001-02-22 09:21:12 | Re: [GENERAL] problem while compiling user c functions in 7.1beta4 |
Previous Message | hubert depesz lubaczewski | 2001-02-22 07:28:46 | problem while compiling user c functions in 7.1beta4 |