update a table from a temp table

From: Charles Holleran <scorpdaddy(at)hotmail(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: update a table from a temp table
Date: 2010-08-17 18:09:44
Message-ID: BAY126-W172243E3B33B12D72D4EB7CE9C0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Referring to the syntax for updating a table from a temp table at "Update a field in a table using a value from another table ..." at

http://www.cryer.co.uk/brian/sql/sql_crib_sheet.htm

Is this the correct syntax for PG for updating a table from a temp table?


Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Thom Brown 2010-08-17 18:20:58 Re: update a table from a temp table
Previous Message Thom Brown 2010-08-16 18:43:48 Re: Can I use check-constraint to set null?