reference to 'as' field

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: reference to 'as' field
Date: 2005-09-01 15:11:59
Message-ID: 5.2.1.1.0.20050901110534.043f3aa0@pop6.sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

When I use "select (f1+f2+f3+f4+f5) as f0 ..." in 7.4.3, it seems I can use
"f0" is "order by", but not "where" clause [column 'f0' does not
exist]? Does this change in more current versions? Is there a list of
which clauses support this syntax in which versions?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2005-09-01 16:40:22 Debian PostgreSQL Install
Previous Message Toff 2005-09-01 13:09:55 Inserting data in other db