Probably because the bit after the SET is a column-name not a
reference to a column. There's no point qualifying it in any way since
the tablename is given as part of the UPDATE statement.
On Tue, Nov 09, 2004 at 06:33:55PM -0800, John Fabiani wrote:
From the 7.4 docs:
A column can be
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.
John
On Wednesday 10 November 2004 03:31, Martijn van Oosterhout wrote:
Probably because the bit
John Fabiani wrote:
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.
Surely MySQL would also support writing a column name without a table
name?
--
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
From the 7.4 docs:
A column can be referenced in the form
correlation.columnname
correlation is the name of a table (possibly qualified with a schema name), or
an alias for a table defined by means of a FROM clause, or one of the key
words NEW or OLD. (NEW and OLD can only appear in rewrite