Re: Inserting a select statement result into another table

Hello,

just my $0.02...
If I do
insert into x
select * from y limit 10;

I will get all of rows in x inserted, not just 10...
I already wrote about this... But did not get any useful reply.

> This is an interesting idea. We don't allow ORDER BY in INSERT INTO ...
> SELECT because it doesn't make any sense, but it does make sense if
> LIMIT is used:
>
> ctest=> create table x (Y oid);
> CREATE
> test=> insert into x
> test-> select oid from pg_class order by oid limit 1;
> ERROR: LIMIT is not supported in subselects
>
> Added to TODO:
>
> Allow ORDER BY...LIMIT in INSERT INTO ... SELECT

--
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp(at)perchine(dot)com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------