Postgres Pro
Downloads
Home   >   mailing lists

self-join on subselect - Mailing list pgsql-general

From PFC
Subject self-join on subselect
Date
Msg-id opsk8dazxeth1vuj@musicbox
Whole thread Raw
In response to Re: Calculating a moving average (Coding style)  (mstory@uchicago.edu)
Responses Re: self-join on subselect
Re: self-join on subselect
List pgsql-general
Tree view 
    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
..................................?

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: text field constraint advice
Next
From: PFC
Date:
Subject: Re: Calculating a moving average