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

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.

And by Tom:
http://archives.postgresql.org/pgsql-general/2002-11/msg01411.php

Tom's explanation makes perfect sense, thanks for the pointer.

Regards,
Daniel Serodio