Postgres Pro
Downloads
Home   >   mailing lists

How to use outer join in update - Mailing list pgsql-general

From Andrus
Subject How to use outer join in update
Date
Msg-id el9l1e$rh4$1@news.hub.org
Whole thread Raw
Responses Re: How to use outer join in update  (Alban Hertroys <alban@magproductions.nl>)
List pgsql-general
Tree view 
In my current DBMS I can use

create table t1 ( f1 int, f2 int );
create table t2 ( f3 int, f4 int );
update t1 set f1=t2.f3 from t1 left join t2 on  t1.f2=t2.f4


This does not work in Postgres.

How to convert this statement to Postgres 8.1 ?

Andrus.

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: The relative stability of different procedural
Next
From: "Lenorovitz, Joel"
Date:
Subject: Help with Update Rule on View - 2nd Attempt