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
address=# var = select max(id) from passwd;
ERROR: parser: parse error at or near "var" at character 1
address=# :var = select max(id) from passwd;
ERROR: parser: parse error at or near ":" at character 1
address=#
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?
--
joe speigle