Thus spake ZEUGSWETTER Andreas IZ5
> > Allow "col AS name" to use name in WHERE clause? Is this ANSI?
> > Works in GROUP BY
> 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 ?
Not to me. What if I don't know that a c exists in the table, or it is
added after creating many scripts? I think we should use the alias in
that case. Either that or it should generate an error.
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.