Re: Why UPDATE gl SET gl.glnum = gl.glnum; cause error

On Fri, 8 Jul 2005, David Gagnon wrote:

> 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 ?

For at least 92 (and I'm almost certain 99) not in the SET list.  It uses
column name (which is a plain identifier) rather than a column reference.