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.