Question about update syntaxt - Mailing list pgsql-sql

From Michael M Friedel
Subject Question about update syntaxt
Date
Msg-id 5BD9C777-3A63-4A00-8B4B-F1BB5C230893@betty-tv.com
Whole thread Raw
Responses Re: Question about update syntaxt  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-sql
I am trying to use an application (Through ODBC) that uses the  
following update syntax

UPDATE MyTable SET MyTable.id=2 WHERE id=1

unfortunatly I get an error message

ERROR:  column "mytable" of relation "mytable" does not exist

Question is, is ther something I can configure that will make  
Postgresql accept these kind of statments ?




------------------------------------
Michael M Friedel
Research & Development





pgsql-sql by date:

Previous
From: "Igor Kryltsov"
Date:
Subject: Re: Help to drop table
Next
From: Tony Wasson
Date:
Subject: Re: Looking for a way to sum integer arrays....