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;
>From: Tom Lane
>To: "Richard Huxton"
>CC: "Matteo Centenaro" , pgsql-general@postgresql.org
>Subject: Re: [GENERAL] Insert and limit
>Date: Fri, 15 Jun 2001 10:42:11 -0400
>
>"Richard Huxton" writes:
> > [follow-up message said Matteo was interested in plpgsql]
> > Still seems OK.
>
>I think a more relevant question is "what version are you running?"
>
>IIRC, LIMIT only works in a top-level SELECT before 7.1.
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.