> Allow "col AS name" to use name in WHERE clause? Is this ANSI?
> Works in GROUP BY
>
Neighter Informix nor Oracle do it, so it is probably not ansi, but it would
be a very neat feature, especially if you do some arithmetic,
the statement gets a lot clearer.
But it probably adds some complexity:
create table a (a int, b int, c int);
select a, b as c from a where c=5;
Which c do you use alias or column ? You prbly need to use the column,
since this is how all others work, but would this be intuitive ?
Andreas