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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs