Ooops. apologies. I've been in mysql too long.
Charley
On Dec 13, 2005, at 11:49 AM, Michael Fuhr wrote:
> On Tue, Dec 13, 2005 at 11:37:00AM -0600, Charley Tiggs wrote:
>> There needs to be a reference to t_serial_number in the update
>> clause:
>>
>> UPDATE t_job_number, t_serial_number
>> SET contract_id = 30
>> WHERE t_serial_number.serial_number_id = 78
>> AND t_serial_number.job_number_id =
>> t_job_number.job_number_id
>
> No version of PostgreSQL that I tested (7.3 and later) allows that
> syntax, and it's not shown in the documentation.
>
> ERROR: syntax error at or near "," at character 20
> LINE 1: UPDATE t_job_number, t_serial_number
> ^
>
> --
> Michael Fuhr
