Re: RFE: Column aliases in WHERE clauses - Mailing list pgsql-general

From Chris Angelico
Subject Re: RFE: Column aliases in WHERE clauses
Date
Msg-id CAPTjJmoWQkUvLyby4aD6=yonONQ08tCO8eCNGMpdqi=2NSoVPQ@mail.gmail.com
Whole thread Raw
In response to Re: RFE: Column aliases in WHERE clauses  ("David Johnston" <polobo@yahoo.com>)
Responses Re: RFE: Column aliases in WHERE clauses
List pgsql-general
On Wed, Sep 19, 2012 at 11:15 PM, David Johnston <polobo@yahoo.com> wrote:
> I could maybe see something like the following having some value:
>
> SELECT inverse
> FROM data
> WHERE x<>0 AND inverse > .5
> MACRO inverse (1/x)
>

WITH macros AS (SELECT *,1/x AS inverse FROM data) SELECT inverse FROM
macros WHERE x<>0 AND inverse > .5

ChrisA


pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Passing row set into PL/pgSQL function.
Next
From: "Carrington, Matthew (Produban)"
Date:
Subject: pg_upgrade: out of memory