update from select - Mailing list pgsql-sql

From Gary Stainburn
Subject update from select
Date
Msg-id 200310290911.54453.gary.stainburn@ringways.co.uk
Whole thread Raw
Responses Re: update from select
List pgsql-sql
Hi folks,

don't know if it's cos of the 17 hours I've just worked (sympathy vote please) 
but I can't get this one worked out

I've got table names with nid as name id field and nallowfollow flag.
I've got a vehicles table with vowner pointing at nid and a vallowfollow 
field.

How can I update nallowfollow from the appropriate vallowfollow flag?
-- 
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000     



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Table versions
Next
From: Jeff Kowalczyk
Date:
Subject: Help on update that subselects other records in table, uses joins