chester c young <[EMAIL PROTECTED]> writes:
>> SELECT field1 / 2 AS foo,
>> field2 * 2 AS bar,
>> foo + bar AS total
>> WHERE foo < 12;
> First, I think it would be great if this worked - like the alias to an
> update table added in 8.2 - saves a lot of typing and makes queries
> much more readable.
This is not an "extension", it is *directly* contrary to both the letter
and spirit of the SQL standard. I can hardly believe that M$ did that
... oh, actually, I can entirely believe it. The OP has a serious
problem of vendor lockin now, and that's exactly what M$ wants.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
