Right, I understand that fully, and have used SQL inside a stored proc
before, but in this case as I mentioned, I need to first do a select
from a table to get a max value, store that in a variable and then use
that variable in a create sequence sql statement.
so I need to construct a string that contains the create sequence
statement and execute that string, at least this is the way it is done
in Oracle.
I do not know how to use a variable in a create sequence statement in
PostgreSQL.
J.V.
On 4/27/2012 9:51 AM, Merlin Moncure wrote:
On Fri, Apr 27, 2012 at 10:37 AM, J.V.<jvsrvcs@xxxxxxxxx> wrote:
I need to create a sequence in a stored procedure.
First I need to select a value from a table and set the sequence start value
to that value.
We have a table that does not have a sequence on it, so I want to select the
max value, increment by one
and then start the sequence there.
We have to do this on three databases, I have figured out how to do this in
Oracle (build a string and the EXECUTE IMMEDIATE<myString>, but have not
figured out how to do this with PostgreSQL.
just about any sql is allowed from within a function, including CREATE
SEQUENCE. functions can even create functions and execute them.
merlin
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
