insert using select with limit
Theo Kramer <theo@flame.co.za>
From: Theo Kramer <theo@flame.co.za>
To: hackers@postgresql.org
Date: 1999-12-10T10:57:17Z
Lists: pgsql-hackers
Hi Just noticed that limit is ignored when using a select to insert into a table. Eg. insert into mytable (f1, f2) select f1, f2 from myothertable limit 10; selects all records from myothertable. Using the select with limit on it's own works fine. Version 6.5.2 on RH6 -------- Regards Theo