On 12/05/11 00:19, Grzegorz Szpetkowski wrote:
Is there any "proper", standard ordering that I can assume for sure ?
Maybe PostgreSQL 8.4/9.0 versions have strict ordering and older
versions are using mixed ordering depends on something I don't know (I
am just guessing).
Queries do not have any
I am curious what is proper ordering for cross joining and joining at
all for two tables. I look at the example at
http://www.postgresql.org/docs/9.0/static/queries-table-expressions.html
and there is:
SELECT * FROM t1 CROSS JOIN t2;
num | name | num | value
-+--+-+---
1 | a