If I insert using the results of a select statement, are the inserts
guaranteed to happen in the order of the rows returned from the select?

That is, are these two equivalent:

    INSERT INTO <table2> SELECT <field> FROM <table1> ORDER BY <col> DESC;


    FOR row IN SELECT <field> FROM <table1> ORDER BY <col> DESC LOOP
        INSERT INTO <table2> VALUES (row.<field>);

I read through the SQL spec on insertion but they don't address insertion
ordering (perhaps, purposefully).

Any clarification here would be super helpful.

Thank you!

Reply via email to