Re: RFE: Column aliases in WHERE clauses

From: Ryan Kelly <rpkelly22(at)gmail(dot)com>
To: "Daniel Serodio (lists)" <daniel(dot)lists(at)mandic(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: RFE: Column aliases in WHERE clauses
Date: 2012-09-17 21:42:24
Message-ID: 20120917214224.GD16206@llserver.lakeliving.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

>
> Thanks in advance,
> Daniel Serodio
>

-Ryan Kelly

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Angelico 2012-09-17 21:57:28 Re: Official C++ API for postgresql?
Previous Message Fabrízio de Royes Mello 2012-09-17 21:23:59 Re: when was a db/schema created ?