self-join on subselect

From: PFC <lists(at)boutiquenumerique(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: self-join on subselect
Date: 2005-01-26 22:12:25
Message-ID: opsk8dazxeth1vuj@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


How do you do a self-join on a subselect ?

like
SELECT a.x+b.x FROM (subselect) a, (subselect) b WHERE a.id = b.id+10

but without performing the subselect twice
..................................?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message PFC 2005-01-26 22:20:35 Re: Calculating a moving average
Previous Message Michael Fuhr 2005-01-26 21:59:22 Re: text field constraint advice