Re: selecting into a variable like @var=select ... - Mailing list pgsql-general

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