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

From Stephan Szabo
Subject Re: How do I replace select ... into commands?
Date
Msg-id 20030911194512.Q47864-100000@megazone.bigpanda.com
Whole thread Raw
In response to How do I replace select ... into commands?  ("Richard Sydney-Smith" <richard@ibisaustralia.com>)
List 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 by date:

Previous
From: "Richard Sydney-Smith"
Date:
Subject: How do I replace select ... into commands?
Next
From: "Richard Sydney-Smith"
Date:
Subject: Re: How do I replace select ... into commands?