How do I replace select ... into commands? - Mailing list pgsql-sql

From Richard Sydney-Smith
Subject How do I replace select ... into commands?
Date
Msg-id 001501c378d6$3aa78f20$df6c32d2@athlon2000
Whole thread Raw
Responses Re: How do I replace select ... into commands?  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-sql
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?
 
much thanks for the earlier help.
 
Sincerely
Richard Sydney-Smith
 

pgsql-sql by date:

Previous
From: Tomasz Myrta
Date:
Subject: Re: MD5 function is not available ?
Next
From: Stephan Szabo
Date:
Subject: Re: How do I replace select ... into commands?