insert using select with limit

From: Theo Kramer <theo(at)flame(dot)co(dot)za>
To: hackers(at)postgresql(dot)org
Subject: insert using select with limit
Date: 1999-12-10 10:57:17
Message-ID: 3850DC8D.C412E16C@flame.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Browse pgsql-hackers by date

  From Date Subject
Next Message Don Baccus 1999-12-10 11:08:52 Re: [HACKERS] RE: What database i can use? (fwd)
Previous Message Tatsuo Ishii 1999-12-10 10:30:57 Re: [HACKERS] FreeBSD problem under heavy load