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@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------