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
