Home > mailing lists

Update Join ? - Mailing list pgsql-general

From	kevin kempter
Subject	Update Join ?
Date	April 1, 2008 21:51:37
Msg-id	44057B51-3397-4779-BF4C-8532C5C6E36B@kevinkempterllc.com Whole thread Raw
Responses	Re: Update Join ? ("Adam Rich" <adam.r@sbcglobal.net>)
List	pgsql-general

Hi List;

Does Postgres allow updates based on the context of a sub-query, something like the sample below ?

1) Insert data (real_tab.keyID and real_tab.data_desc) into a temp table (temp_tab)

2) update real_tab

set real_tab.data_desc = temp_tab.data_desc

join real_tab on real_tab.keyID = temp_tab.keyID ;

Thanks in advance..

From: "Jeff Wigal (Referee Assistant)"
Date: 01 April 2008, 21:44:14
Subject: Re: Connection reset by peer / broken pipe

From: "Adam Rich"
Date: 01 April 2008, 21:56:59
Subject: Re: Update Join ?