I try to execute the select and all seem fine! The limit statement appear in
the right position.The prolang field is set to 18759392.
Have any other idea? Thanks
>From: Richard Huxton <dev@archonet.com>
>To: Matteo Centenaro <gente_che_mixa@hotmail.com>
>CC: pgsql-general@postgresql.org
>Subject: Re: [GENERAL] Insert and limit
>Date: Sat, 16 Jun 2001 08:12:21 +0100
>
>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
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.