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
обсуждение исходный текст
Ответ на How do I replace select ... into commands?  ("Richard Sydney-Smith" <richard@ibisaustralia.com>)
Список pgsql-sql
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"
Дата:
Сообщение: How do I replace select ... into commands?
Следующее
От: "Richard Sydney-Smith"
Дата:
Сообщение: Re: How do I replace select ... into commands?