Re: RFE: Column aliases in WHERE clauses

On Sep 17, 2012, at 17:42, Ryan Kelly  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 elsewhere if warranted.

David J.