Re: CREATE SEQUENCE fails in plpgsql function - Mailing list pgsql-sql

On Mon, 30 Jun 2003, Erik Erkelens wrote:

>         new_max_records ALIAS FOR $1;
>     BEGIN
>         DROP SEQUENCE my_sequence;
>         --CREATE SEQUENCE my_sequence MAXVALUE 4
> CYCLE;
>         CREATE SEQUENCE my_sequence MAXVALUE
> new_max_records CYCLE;

Most of the creates/drops/etc... don't directly work with
variables/arguments.  You can probably do this with execute
however.