Postgres Pro
Downloads
Home   >   mailing lists

Re: the column in Update - Mailing list pgsql-general

From Tom Lane
Subject Re: the column in Update
Date
Msg-id 2146.1100132602@sss.pgh.pa.us
Whole thread Raw
In response to Re: the column in Update  (John Fabiani <jfabiani@yolo.com>)
List pgsql-general
Tree view 
John Fabiani <jfabiani@yolo.com> 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

pgsql-general by date:

Previous
From: "Net Virtual Mailing Lists"
Date:
Subject: Re: Important Info on comp.databases.postgresql.general
Next
From: "Mike Cox"
Date:
Subject: Postgresql future changes