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.
any ideas?
thanks
J.V.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
