[SQL] Why is PostgreSQL 7.0 SQL semantics different from Oracle's?

2000-05-24 Thread Thomas Holmgren
ifferent result! It seems that Postgres executes the natural join in the query BEFORE performing the sum() in the definition of the views thus giving me a wrong result. How can I fix that?? How come PostgreSQL uses different semantics when evaluating SQL expressions than other BDMSs? Th

[SQL] Why is PostgreSQL 7.0 SQL semantics different from Oracle's?

2000-05-24 Thread Thomas Holmgren
ifferent result! It seems that Postgres executes the natural join in the query BEFORE performing the sum() in the definition of the views thus giving me a wrong result. How can I fix that?? How come PostgreSQL uses different semantics when evaluating SQL expressions than other BDMSs? Tha