Re: the column in Update - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: the column in Update
Date
Msg-id 20041110113149.GD30620@svana.org
Whole thread Raw
In response to the column in Update  (John Fabiani <jfabiani@yolo.com>)
Responses Re: the column in Update
List pgsql-general
Probably because the bit after the SET is a "column-name" not a
reference to a column. There's no point qualifying it in any way since
the tablename is given as part of the UPDATE statement.

On Tue, Nov 09, 2004 at 06:33:55PM -0800, John Fabiani wrote:
> From the 7.4 docs:
>  A column can be referenced in the form
>
> correlation.columnname
>
> correlation is the name of a table (possibly qualified with a schema name), or
> an alias for a table defined by means of a FROM clause, or one of the key
> words NEW or OLD. (NEW and OLD can only appear in rewrite rules, while other
> correlation names can be used in any SQL statement.) The correlation name and
> separating dot may be omitted if the column name is unique across all the
> tables being used in the current query. (See also Chapter 7.)
>
> So then why does this not work:
> Update tablename set tablename.columnName = 'somedata' where .....
>
> John
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Trying to get postgres to use an index
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Lost databases