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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Fri, 19 Feb 2010 10:32:03 +0000
  • Message-id: <C7A41923.474C%gr306@staff-ad.csi.cam.ac.uk> <text/plain>

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




Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group