Re: insert order question

See here:

http://www.postgresql.org/docs/9.0/static/sql-values.html

Implied is that the supplied data set will be returned in the same order as
written unless an ORDER BY is used to re-order the listing prior to it being
spit out the other end.

1, 3, 2 = > VALUES = > 1, 3, 2

1, 3, 2 = > VALUES ORDER ASC = > 1, 2, 3

The only time you end up with ordering issues is the "FROM 'physical table'"
because there is no defined order for how those records are stored into
memory; but when you explicitly list a set of data that explicit order is
maintained as long as possible.

David J.

From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Gauthier, Dave
Sent: Thursday, May 12, 2011 3:37 PM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] insert order question

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 !