Re: [SQL] CROSS JOIN ordering

2011-05-12 Thread Richard Huxton
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

[SQL] CROSS JOIN ordering

2011-05-11 Thread Grzegorz Szpetkowski
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