Re: How do I replace select ... into commands?

Поиск
Список
Период
Сортировка
Искать
От
Stephan Szabo
Тема
Re: How do I replace select ... into commands?
Дата
Msg-id
20030911194512.Q47864-100000@megazone.bigpanda.com
Ответ на
Список
Дерево обсуждения
Re: How do I replace select ... into commands? "Richard Sydney-Smith" <richard@ibisaustralia.com>
On Fri, 12 Sep 2003, Richard Sydney-Smith wrote:

> I have a number of sybase procedures in which I use something like
>
> declare
> mx : integer;
> begin
> select max(field) from table into mx;
> return mx;
> end;
>
> Postgresql is telling me that select...into has not been implemented
> yet. what is the best way to perform this action with the commands
> offered in plpgsql?

Something like the above should work, what's the exact function and error
message and what version are you using?


В списке pgsql-sql по дате отправления
От: Richard Sydney-Smith
Дата:
От: Richard Sydney-Smith
Дата:
FAQ