<html><DIV>
<P>I'm running 7.1.1</P>
<P>I create the Pl/Pgsql function using Pgaccess the code is like this:<BR>Insert into tab1 Select * from tab2 where id = xxxx limit var_name;</P></DIV>
<DIV></DIV>
<DIV></DIV>>From: Tom Lane <TGL(at)SSS(dot)PGH(dot)PA(dot)US>
<DIV></DIV>>To: "Richard Huxton" <DEV(at)ARCHONET(dot)COM>
<DIV></DIV>>CC: "Matteo Centenaro" <GENTE_CHE_MIXA(at)HOTMAIL(dot)COM>, pgsql-general(at)postgresql(dot)org
<DIV></DIV>>Subject: Re: [GENERAL] Insert and limit
<DIV></DIV>>Date: Fri, 15 Jun 2001 10:42:11 -0400
<DIV></DIV>>
<DIV></DIV>>"Richard Huxton" <DEV(at)ARCHONET(dot)COM>writes:
<DIV></DIV>> > [follow-up message said Matteo was interested in plpgsql]
<DIV></DIV>> > Still seems OK.
<DIV></DIV>>
<DIV></DIV>>I think a more relevant question is "what version are you running?"
<DIV></DIV>>
<DIV></DIV>>IIRC, LIMIT only works in a top-level SELECT before 7.1.
<DIV></DIV>>
<DIV></DIV>> regards, tom lane
<DIV></DIV>>
<DIV></DIV>>---------------------------(end of broadcast)---------------------------
<DIV></DIV>>TIP 3: if posting/reading through Usenet, please send an appropriate
<DIV></DIV>>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
<DIV></DIV>>message can get through to the mailing list cleanly
<DIV></DIV><br clear=all><hr>Get Your Private, Free E-mail from MSN Hotmail at <a href="http://www.hotmail.com">http://www.hotmail.com</a>.<br></p></html>