Daniel Cristian Cruz escribió:
> Humm...
>
> Reading this way... It sounds like I could write something like this:
>
> SELECT city, (temp_hi+temp_lo)/2 temp_avg, date FROM weather;
>
> Like it work with tables...
Well, it says "the AS clause", not "the AS keyword". The keyword itself
is not optional if you want to have the clause at all.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support