Postgres Pro
Downloads
Home   >   mailing lists

Why UPDATE gl SET gl.glnum = gl.glnum; cause error when UPDATE gl SET glnum = glnum; is OK ? - Mailing list pgsql-general

From David Gagnon
Subject Why UPDATE gl SET gl.glnum = gl.glnum; cause error when UPDATE gl SET glnum = glnum; is OK ?
Date
Msg-id 42CE86A7.2070101@siunik.com
Whole thread Raw
In response to Postgresql is not able to find a stored procedure with a smallint instead of integer in signature  (David Gagnon <dgagnon@siunik.com>)
Responses Re: Why UPDATE gl SET gl.glnum = gl.glnum; cause error
Re: Why UPDATE gl SET gl.glnum = gl.glnum; cause error when UPDATE gl SET glnum = glnum; is OK ?
List pgsql-general
Tree view 
Hi all,

I was juste wondering why the following code don't work:
 UPDATE gl SET gl.glnum = gl.glnum
ERROR:  column "gl" of relation "gl" does not exist

While the following works:
UPDATE gl SET glnum = glnum;

Query returned successfully: 177 rows affected, 281 ms execution time.

the TABLE.COLUMN is not in the SQL standard ?

Thanks
/David

pgsql-general by date:

Previous
From: postgresql@bryden.co.za
Date:
Subject: PostgreSQL Scalability
Next
From: Stephan Szabo
Date:
Subject: Re: Why UPDATE gl SET gl.glnum = gl.glnum; cause error