Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group