Re: ALTER SEQUENCE ... RESTART WITH [variable] problem - Mailing list pgsql-general

On 5/20/06, Martijn van Oosterhout <kleptog@svana.org> wrote:

> Seems you can't use a variable there. Your choices are to build a
> string and use EXECUTE, or just do:
>
> SELECT setval('sequence',value);

The EXECUTE string solution did the job. Thank you very much, Martijn.

t.n.a.