[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

Re: [SQL] BINARY and BINARY VARYING datatypes in PostgreSQL

2011-05-03 Thread Grzegorz Szpetkowski
Thank you for comprehensive answer. You are right, it is better to implement what users really need in their work, but I believe that people who writing SQL Standard want to give it pragmatic and usable. Regards, Grzegorz Szpetkowski 2011/5/3 Susanne Ebrecht : > On 02.05.2011 12:46, Grzeg

[SQL] BINARY and BINARY VARYING datatypes in PostgreSQL

2011-05-02 Thread Grzegorz Szpetkowski
al features. It might be worth noting that at the time of writing, no current version of any database management system claims full conformance to Core SQL:2008." from: http://developer.postgresql.org/pgdocs/postgres/features.html Regards, Grzegorz Szpetkowski -- Sent via pgsql-sql mai