Re: sequence and stored procedure - Mailing list 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