insert order question

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: insert order question
Date: 2011-05-12 19:36:32
Message-ID: 482E80323A35A54498B8B70FF2B879800493F1FE15@azsmsx504.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 !

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-05-12 19:51:53 Re: How to handle bogus nulls from ActiveRecord
Previous Message raghu ram 2011-05-12 18:36:56 Re: Postgredac Dump