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