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

Re: What is wrong with this SQL

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: norman(at)khine(dot)net
Cc: "Pgsql-Novice" <pgsql-novice(at)postgresql(dot)org>,pgsql-novice-owner(at)postgresql(dot)org
Subject: Re: What is wrong with this SQL
Date: 2002-08-14 20:13:33
Message-ID: OFAC9EAF00.5D396342-ON88256C15.006F01C3-88256C15.006F0E6B@fds.com (view raw or flat)
Thread:
Lists: pgsql-novice
It appears you aren't updating any fields (or I'm looking at it wrong):

UPDATE SOME_TABLE
SET FIELD1 = SOME_VALUE
From
(price RIGHT JOIN product ON price.product = product.id) RIGHT JOIN
supplier ON product.supplier = supplier.id SET price.price = 200
WHERE (((supplier.id)=4) AND ((supplier.status)=1) AND
((product.status)=1) AND ((price.type)=1) AND ((product.id)=100902));


Patrick Hatcher




|--------+--------------------------------->
|        |          "Norman Khine"         |
|        |          <norman(at)khine(dot)net>     |
|        |          Sent by:               |
|        |          pgsql-novice-owner(at)post|
|        |          gresql.org             |
|        |                                 |
|        |                                 |
|        |          08/14/2002 12:56 PM    |
|--------+--------------------------------->
  >----------------------------------------------------------------------------------------------------------|
  |                                                                                                          |
  |      To:     "Pgsql-Novice" <pgsql-novice(at)postgresql(dot)org>                                                |
  |      cc:                                                                                                 |
  |      Subject:     [NOVICE] What is wrong with this SQL                                                   |
  >----------------------------------------------------------------------------------------------------------|




Hello,
I am a bit stuck on this UPDATE query

UPDATE (price RIGHT JOIN product ON price.product = product.id) RIGHT JOIN
supplier ON product.supplier = supplier.id SET price.price = 200
WHERE (((supplier.id)=4) AND ((supplier.status)=1) AND
((product.status)=1) AND ((price.type)=1) AND ((product.id)=100902));

This works.... but the above query gets a exception error "("

SELECT supplier.id, price.price, product.id FROM (price RIGHT JOIN
product ON price.product = product.id) RIGHT JOIN supplier ON
product.supplier = supplier.id WHERE (((su
pplier.id)=4) AND ((supplier.status)=1) AND ((product.status)=1) AND
((price.type)=1) AND ((product.id)=100902));

Thanks

zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
zz/********/z/****\zzz|****\*\zz|*******|z
z/^^^^^^^^/z/******\zz|*^^^^|*|z|*|^^^^^|z norman khine
zzzzzz/**/z|**/^^\**|z|*|zzz|*|z|*|zzzzzzz mailto:norman(at)khine(dot)net
zzzzz/**/zz|*|zzzz|*|z|****/*/zz|*****|zzz purley
z/******/zz|*|zzzz|*|z|*|^^zzzzz|*|^^^|zzz UK
zzZ/**/zzzz|**\^^/**|z|*|zzzzzzz|*|zzzzzzz
zz/******/zz\******/zz|*|zzzzzzz|*|*****|z
z/^^^^^^/zzzz\^^^^/zzz|^|zzzzzzz|^^^^^^^|z
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org




Responses

pgsql-novice by date

Next:From: Oliver ElphickDate: 2002-08-14 20:14:54
Subject: Re: I need to know password for postgres
Previous:From: David RobertsonDate: 2002-08-14 20:04:22
Subject: Re: I need to know password for postgres

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