Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL subquery question - Mailing list pgsql-general

From Alban Hertroys
Subject Re: SQL subquery question
Date
Msg-id 455B1A54.7000508@magproductions.nl
Whole thread Raw
In response to SQL subquery question  (Rick Schumeyer <rschumeyer@ieee.org>)
Responses Re: SQL subquery question  (Rick Schumeyer <rschumeyer@ieee.org>)
List pgsql-general
Tree view 
Rick Schumeyer wrote:
> foreach f in tsubset
>  update tsubset set k=(select k from t, tsubset where t.f=f);
> end
>
> Can this be done with one SQL statement?

I think you mean
update tsubset set k = t.k from t where t.f = f;

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
   7500 AK Enschede

// Integrate Your World //

pgsql-general by date:

Previous
From: Rick Schumeyer
Date:
Subject: SQL subquery question
Next
From: Matthias.Pitzl@izb.de
Date:
Subject: Question about query optimization