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

Re: Problem UPDATE Statement

From: <operationsengineer1(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Problem UPDATE Statement
Date: 2006-01-04 23:23:15
Message-ID: 20060104232315.24478.qmail@web33313.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
> <operationsengineer1(at)yahoo(dot)com> writes:
> > i'm trying to apply the following UPDATE
> statement:
> > UPDATE t_sn
> > SET t_sn.sn_completed = false
> > WHERE sn = 1
> > AND t_sn.link_id = t_link.link_id
> > AND t_link.job_id = t_job.job_id
> > AND t_job.product_id = t_product.product_id
> > AND t_product.product_id = 118
> 
> > i get the following error:
> 
> > ERROR:  missing FROM-clause entry for table
> "t_link"
> 
> You need a "FROM t_link" in there.  Prior versions
> of PG were laxer
> about this, but it's been a very long time since
> this command wouldn't
> draw at least a NOTICE ...
> 
> 			regards, tom lane

Tom, thanks.  that was it.  the basic examples didn't
include the FROM clause - i surmise it isn't required
until you start traversing across linked tables.

this worked...

UPDATE t_sn
SET sn_completed = false
FROM t_link, t_job, t_product
WHERE sn = 1
AND t_sn.link_id = t_link.link_id
AND t_link.job_id = t_job.job_id
AND t_job.product_id = t_product.product_id
AND t_product.product_id = 118

thanks again.


		
__________________________________________ 
Yahoo! DSL – Something to write home about. 
Just $16.99/mo. or less. 
dsl.yahoo.com 


In response to

pgsql-novice by date

Next:From: Michael FuhrDate: 2006-01-05 00:31:53
Subject: Re: foreign key's in system tables
Previous:From: Sean DavisDate: 2006-01-04 23:15:04
Subject: Re: GRANT access rights on rows

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