UPDATE with value from another table - Mailing list pgsql-general

From Thomas T. Thai
Subject UPDATE with value from another table
Date
Msg-id Pine.NEB.4.43.0203012304270.28289-100000@ns01.minnesota.com
Whole thread Raw
Responses Re: UPDATE with value from another table
List pgsql-general
UPDATE [ ONLY ] table SET col = expression [, ...]
    [ FROM fromlist ]
    [ WHERE condition ]

Is this valid:

  UPDATE table1
  SET col = table2.col
  FROM table2
  WHERE col = table2.id;



pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: PostgreSQl or BerkeleyDB ??
Next
From: Francisco Reyes
Date:
Subject: Re: Is vacuum full lock like old's vacuum's lock?