John Fabiani <[EMAIL PROTECTED]> writes:
> Thanks but in the doc's it uses the term 'columnname'. The real issue is the
> tablename.columnname is supported in MySQL and I'm trying to support Postgres
> and MySQL with a single code routine.
If you want portable code, I suggest conforming to the SQL-standard
syntax. The table name is disallowed there according to the spec.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
