Re: Insert and limit

<div><p>I'm running 7.1.1<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;</div><div></div><div></div>>From: Tom Lane  <div></div>>To:
"RichardHuxton"  <div></div>>CC: "Matteo Centenaro" , pgsql-general@postgresql.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"writes: <div></div>> > [follow-up message said Matteo was interested in plpgsql] <div></div>> >
Stillseems 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@postgresql.org so that your <div></div>>message can
getthrough to the mailing list cleanly <div></div><br clear="all" /><hr />Get Your Private, Free E-mail from MSN
Hotmailat <a href="http://www.hotmail.com">http://www.hotmail.com</a>.<br />