Postgres Pro
Downloads
Home   >   mailing lists

insert using select with limit - Mailing list pgsql-hackers

From Theo Kramer
Subject insert using select with limit
Date
Msg-id 3850DC8D.C412E16C@flame.co.za
Whole thread Raw
Responses Re: [HACKERS] insert using select with limit
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [HACKERS] FreeBSD problem under heavy load
Next
From: Vince Vielhaber
Date:
Subject: Re: [HACKERS] 6.6 release