Обсуждение: RFE: Alises in WHERE clauses

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

On 17/09/2012 21:24, 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?

No. :-)

Try pgsql-general instead; this list is for PgAdmin.

Ray.


-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

Raymond O'Donnell wrote: <blockquote cite="mid:50578C24.3020704@iol.ie" type="cite"><pre wrap="">On 17/09/2012 21:24,
DanielSerodio (lists) wrote:
 
</pre><blockquote type="cite"><pre wrap="">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?
</pre></blockquote><pre wrap="">
No. :-)

Try pgsql-general instead; this list is for PgAdmin.
</pre></blockquote> Oops. I meant to post to pgsql-general but autocomplete failed me :-)<br /><br /> Regards,<br />
DanielSerodio<br /><br />