Re: how to create a sequence in a stored proc?

On Fri, Apr 27, 2012 at 10:37 AM, J.V. <jvsrvcs(at)gmail(dot)com> 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