Reuse of Subselects - Mailing list pgsql-general

From Holger Marzen
Subject Reuse of Subselects
Date
Msg-id Pine.LNX.4.58.0402171259380.22598@bluebell.marzen.de
Whole thread Raw
Responses Re: Reuse of Subselects  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Reuse of Subselects  ("P.J. \"Josh\" Rovero" <rovero@sonalysts.com>)
Re: Reuse of Subselects  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
Hi all,

if I have something like this:

SELECT column1,
       (... complicated subselect ...),
       column1 - (... same subselect as above ...)
FROM table1;

do I really have to rewrite the subselect a 2nd time if I need that
result in another column's expression?

pgsql-general by date:

Previous
From: Pascal Polleunus
Date:
Subject: Re: function returning a record
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Reuse of Subselects