Try
EXECUTE ''SELECT MAX(''||column||'') INTO lp FROM '' || table;
This should work but haven't tested it.
Normally with select into though is is
select foo into bar from aa where id = _id;
HTH
On Thu, 3 Oct 2002, 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?
>
> Thaks, Wojtek
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
--
Darren Ferguson
