Why UPDATE gl SET gl.glnum = gl.glnum; cause error when UPDATE gl SET glnum = glnum; is OK ?

Поиск
Список
Период
Сортировка
От David Gagnon
Тема Why UPDATE gl SET gl.glnum = gl.glnum; cause error when UPDATE gl SET glnum = glnum; is OK ?
Дата
Msg-id 42CE86A7.2070101@siunik.com
обсуждение исходный текст
Ответ на Postgresql is not able to find a stored procedure with a smallint instead of integer in signature  (David Gagnon <dgagnon@siunik.com>)
Ответы 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 ?
Список pgsql-general
Дерево обсуждения 
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 по дате отправления: