On Tuesday 16 December 2003 17:12, joseph speigle wrote:
> hello list,
>
> I want to do something like the following:
>
> address=# @var = select max(id) from passwd;
> ERROR: parser: parse error at or near "@" at character 1
> so that I could then issue
>
> create sequence passwd_id_seq start @var increment 1
>
> how can I declare and capture output into this variable? Or, should I
> create a function, if it is possible to issue a "create" statement inside a
> procedure body?
You'll have to use a function (plpgsql would be the obvious choice). You can
issue almost all statements by building them up in a string and using
EXECUTE.
--
Richard Huxton
Archonet Ltd