Re: PostgreSQL sequence within function

[Tony Caduto <tony_caduto@xxxxxxxxxxxxxxxxxxxx>]

All you where really mising was a semi colon afer nextval('myseq') and
the begin end.

CREATE or REPLACE FUNCTION getSeq()
RETURNS int AS
$$
begin
RETURN nextval('myseq');
end;
$$
LANGUAGE 'plpgsql';

Clark Allan wrote:

> ----------------------------------------------
> CREATE FUNCTION getSeq() 
> RETURNS int AS' 
> RETURN nextval('myseq') 
> 'LANGUAGE 'plpgsql'; 
> ----------------------------------------------
>
> Thanks for the help 
> Clark
>  



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly