Re: Update Query Problem - Mailing list pgsql-novice

From Andreas Kretschmer
Subject Re: Update Query Problem
Date
Msg-id 20051213181108.GA3604@kaufbach.delug.de
Whole thread Raw
In response to Re: Update Query Problem  (<operationsengineer1@yahoo.com>)
List pgsql-novice
operationsengineer1@yahoo.com <operationsengineer1@yahoo.com> schrieb:

> man, you guys are ON IT!  thanks.  the following
> worked like a charm:
>
> UPDATE t_job_number
> SET contract_id = 30
> WHERE job_number_id = (select job_number_id from
> t_serial_number where serial_number_id = 78);

Please read also the mail from 'Jaime Casanova', if the subselect
returns multiple rows.


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

pgsql-novice by date:

Previous
From:
Date:
Subject: Re: Update Query Problem
Next
From: Tom Lane
Date:
Subject: Re: How to recover space from a failed cluster