On Wed, Oct 30, 2002 at 18:02:00 +0000,
Aragorn <aragorn(at)gondor(dot)com> wrote:
> I need to use a calculated start value for some sequences. eg:
>
> CREATE SEQUENCE tblco_cntcoid_key start (SELECT (MAX(cntcoid) + 100)
> FROM tblco) increment 1 maxvalue 2147483647 minvalue 1 cache 1;
I think you need to do this in two steps. First create the sequence
and then use setval to set the starting value. I suspect that the
start value is not allowed to use select. The documention doesn't
make this absolutely clear, but I would be surprised if you could use
one here.