Re: FROM clause in UPDATE

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: FROM clause in UPDATE
Date: 2006-07-17 16:33:40
Message-ID: 200607170933.40731@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Monday 17 July 2006 09:07, "Slavisa Garic" <sgaric(at)gmail(dot)com> wrote:
> The first query will work if I insert "FROM nimrodagent" just before the
> WHERE clause,

The default in 8.1 is to require the FROM clause. I believe there is a
configuration file option to enable the old behaviour.

--
Who are you working for? The average Canadian family pays 47% of
their total income in taxes. If you and your spouse both work, one
of you is working for the government and the other is working for
your family.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bruce Momjian 2006-07-17 19:27:13 Re: [NOVICE] The name of the game
Previous Message Slavisa Garic 2006-07-17 16:07:25 FROM clause in UPDATE