Thread: 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 />