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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
