Greetings!
An update query is apparently succeeding, even though the query refers to
fields that do not exist. Here's the query:
update inventory set
x_coordinate = (select x_coordinate from bases where base = '101'),
y_coordinate = (select y_coordinate from bases where base = '101')
where
On 16 March 2015 at 17:02, Rob Richardson rdrichard...@rad-con.com wrote:
Greetings!
An update query is apparently succeeding, even though the query refers to
fields that do not exist. Here’s the query:
update inventory set
x_coordinate = (select x_coordinate from bases where base =
Rob Richardson wrote:
An update query is apparently succeeding, even though the query refers to
fields that do not exist.
Here’s the query:
update inventory set
x_coordinate = (select x_coordinate from bases where base = '101'),
y_coordinate = (select y_coordinate from bases where base =
Thanks very much. Now that you've explained it, it should have been obvious.
RobR
-Original Message-
From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
Sent: Monday, March 16, 2015 12:21 PM
To: Rob Richardson; pgsql-general@postgresql.org
Subject: RE: Update using non-existent fields