Re: PL/pgSQL

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