Re: Unable to get UPDATE ... FROM syntax correct

From: Gordon Ross <gr306(at)ucs(dot)cam(dot)ac(dot)uk>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Unable to get UPDATE ... FROM syntax correct
Date: 2010-02-19 10:32:03
Message-ID: C7A41923.474C%gr306@staff-ad.csi.cam.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 19/02/2010 10:28, "zkn" <zkn(at)abv(dot)bg> wrote:
> update audit set key = (select extension.number from extension where
> audit.record_id = extension_id)

No joy, I still get "UPDATE 0"

:-(

GTG

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2010-02-19 10:36:21 Re: Unable to get UPDATE ... FROM syntax correct
Previous Message zkn 2010-02-19 10:28:10 Re: Unable to get UPDATE ... FROM syntax correct