>
> > 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 ?
That is an excellent point. GROUP BY has to use a column name, and they
have to be unique, while WHERE does not require stuff to be in the
target list, so there is a change of ambiguity. I am going to remove
the item from the list.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026