Thread: sequence and stored procedure

How can I use sequences in a stored procedure written with pl/pgsql?

Thanks in advance!
Renaud THONNART

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();

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