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

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Richard Sydney-Smith <richard(at)ibisaustralia(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: How do I replace select ... into commands?
Date: 2003-09-12 02:46:28
Message-ID: 20030911194512.Q47864-100000@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Sydney-Smith 2003-09-12 02:59:08 Re: How do I replace select ... into commands?
Previous Message Richard Sydney-Smith 2003-09-12 02:33:12 How do I replace select ... into commands?