insert order question - Mailing list pgsql-general

From Gauthier, Dave
Subject insert order question
Date
Msg-id 482E80323A35A54498B8B70FF2B879800493F1FE15@azsmsx504.amr.corp.intel.com
Whole thread Raw
Responses Re: insert order question
Re: insert order question
List pgsql-general

Hi:

 

Does...

 

               insert into mytbl (col1) values ('a'),('b'),('c');

 

... insert records 'a','b','c' in that order while...

 

               insert into mytbl (col1) values ('c'),('b'),('a');

 

... insert the records in the opposite order?

 

The order matters because there are triggers on the table which will react differently depending on what's already in the table.

 

Thanks in Advance !

 

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Massive delete from a live production DB
Next
From: "David Johnston"
Date:
Subject: Re: How to handle bogus nulls from ActiveRecord