Manfred Koizar <[EMAIL PROTECTED]> writes:
> MSSQL7:
> SELECT t1.f1
> FROM t1 {INNER | LEFT | RIGHT} JOIN t2 ON (t1.f2=t2.f2)
> GROUP BY f1
> all run without an error.
> ORACLE7: JOIN syntax not available, but
> SELECT t1.f1 FROM t1, t2 WHERE (t1.f2=t2.f2) GROUP BY f1;
> SELECT t1.f1 FROM t1, t2 WHERE t1.f2=t2.f2(+) GROUP BY f1;
> SELECT t1.f1 FROM t1, t2 WHERE t1.f2(+)=t2.f2 GROUP BY f1;
> all work.
Okay, that seems to pretty much prove the point. I'll fix parse_agg.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
