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

From David Johnston
Subject Re: RFE: Column aliases in WHERE clauses
Date
Msg-id 8A187125-08CE-42F6-9DF3-F096063BF729@yahoo.com
Whole thread Raw
In response to Re: RFE: Column aliases in WHERE clauses  (Ryan Kelly <rpkelly22@gmail.com>)
List pgsql-general
On Sep 17, 2012, at 17:42, Ryan Kelly <rpkelly22@gmail.com> wrote:

> On Mon, Sep 17, 2012 at 06:18:53PM -0300, Daniel Serodio (lists) wrote:
>> It would be nice if PostgreSQL supported column aliases in WHERE
>> clauses, eg:
>>
>> SELECT left(value, 1) AS first_letter
>> FROM some_table
>> WHERE first_letter > 'a';
>>
>> Is this the proper mailing list for such feature requests?
> I think this is explicitly disallowed by the spec.
>

Just to be clear, the spec does not care where you post your feature requests...it is the feature that it disallows.

When in doubt the general list is a good choice and all the key people monitor it and will move the discussion
elsewhereif warranted. 

David J.

pgsql-general by date:

Previous
From: Chris Angelico
Date:
Subject: Re: Official C++ API for postgresql?
Next
From: "Daniel Serodio (lists)"
Date:
Subject: Re: RFE: Column aliases in WHERE clauses