Re: Insert and limit - Mailing list pgsql-general

Matteo Centenaro wrote:
>
> I'm running 7.1.1
>
> I create the Pl/Pgsql function using Pgaccess the code is like this:
> Insert into tab1 Select * from tab2 where id = xxxx  limit var_name;

Try something like:

select prolang,prosrc from pg_proc where proname='copy_foo';

from psql - I'd guess there's a glitch in the code pgaccess saved.

- Richard Huxton