From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Erik Erkelens <erik_erkelens@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: CREATE SEQUENCE fails in plpgsql function
Date: Mon, 30 Jun 2003 21:49:30 -0700 (PDT)
Message-ID: <20030630214811.D46138-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <20030630145012.88168.qmail@web41707.mail.yahoo.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, erik_erkelens@yahoo.com
Subject: Re: CREATE SEQUENCE fails in plpgsql function
In-Reply-To: <20030630214811.D46138-100000@megazone23.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox