Skip site navigation (1) Skip section navigation (2)

Bug #732: LIMIT clause bugs with insert...select

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #732: LIMIT clause bugs with insert...select
Date: 2002-08-07 12:08:47
Message-ID: 20020807120847.82C44475833@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Guillaume Lafarge (guillaume(dot)lafarge(at)exalog(dot)com) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
LIMIT clause bugs with insert...select

Long Description
The LIMIT clause is not working with SELECT command if SELECT is part of INSERT command.

Sample Code
insert into table1 select * from table2 limit 20;

No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-08-07 13:46:08
Subject: Re: Bug #731: Same SQL produces different results before and after VACUUM FULL
Previous:From: pgsql-bugsDate: 2002-08-07 10:59:13
Subject: Bug #731: Same SQL produces different results before and after VACUUM FULL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group