selecting into a variable like @var=select ...

Поиск
Список
Период
Сортировка
От joseph speigle
Тема selecting into a variable like @var=select ...
Дата
Msg-id 20031216171217.GA5193@www.sirfsup.com
обсуждение исходный текст
Ответы Re: selecting into a variable like @var=select ...
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Authentication Question
Следующее
От: "Rick Gigger"
Дата:
Сообщение: Re: add column sillyness