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

From John Fabiani
Subject Re: the column in Update
Date
Msg-id 200411101527.26452.jfabiani@yolo.com
Whole thread Raw
In response to Re: the column in Update  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: the column in Update
Re: the column in Update
List pgsql-general
Thanks but in the doc's it uses the term 'columnname'.  The real issue is the
tablename.columnname is supported in MySQL and I'm trying to support Postgres
and MySQL with a single code routine.
John
On Wednesday 10 November 2004 03:31, Martijn van Oosterhout wrote:
> 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

pgsql-general by date:

Previous
From: list-pgsql-general@news.cistron.nl ("Miquel van Smoorenburg" )
Date:
Subject: Re: index not always used when selecting on a date field
Next
From: Peter Eisentraut
Date:
Subject: Re: the column in Update