Re: PL/pgSQL - Mailing list pgsql-general

From Patrick Welche
Subject Re: PL/pgSQL
Date
Msg-id 20021004160005.G27710@quartz.newn.cam.ac.uk
Whole thread Raw
In response to PL/pgSQL  ("Wojciech Strza³ka" <wojtek_strzalka@interia.pl>)
List pgsql-general
On Thu, Oct 03, 2002 at 04:53:26PM +0200, Wojciech Strza³ka wrote:
> i've got a simple plsql function and this line is wrong:
>
>    EXECUTE ''SELECT INTO lp MAX('' || column || '') AS MX FROM '' || table
> || '';'';
>
> with error message:
>
> "parse error at or near 'INTO' "
>
> it seems like it don't recognize SELECT INTO - but what's wrong?

How about

 EXECUTE ''SELECT MAX('' || column || '') AS MX INTO lp FROM '' || table

?

Cheers,

Patrick

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performing INSERT from a Trigger fired function
Next
From: Bruce Momjian
Date:
Subject: Re: Postgres for Windows