RFE: Column aliases in WHERE clauses

From: "Daniel Serodio (lists)" <daniel(dot)lists(at)mandic(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: RFE: Column aliases in WHERE clauses
Date: 2012-09-17 21:18:53
Message-ID: 505793BD.5050705@mandic.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks in advance,
Daniel Serodio

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gavin Flower 2012-09-17 21:23:50 Re: log_destination = csvlog
Previous Message Gauthier, Dave 2012-09-17 21:16:27 when was a db/schema created ?