Re: [pgadmin-support] RFE: Alises in WHERE clauses

2012-09-17 Thread Daniel Serodio (lists)
Raymond O'Donnell wrote: 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?

Re: [pgadmin-support] server status window - query is not clearing one SQL is finished (change in behaviour)

2012-09-17 Thread Guillaume Lelarge
On Sun, 2012-09-16 at 07:26 -0600, Doug Easterbrook wrote: > just to add to this change in behaviour > > if I use pgadmin 1.16 against a 9.1.5 database, the current_query goes blank > when the query finished. So the behaviour clearly changes when it is > pgadmin against a 9.2 database. > > >

Re: [pgadmin-support] RFE: Alises in WHERE clauses

2012-09-17 Thread Raymond O'Donnell
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

[pgadmin-support] RFE: Alises in WHERE clauses

2012-09-17 Thread Daniel Serodio (lists)
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 -- Sent via pgadmin-support mailing list