On Thu, 2007-07-12 at 13:23 -0400, Tom Lane wrote: > 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.
"AS" works in Informix, and I believe, in DB2 as well. So it is at least pretty common; I'm not saying it is correct. Since Informix predates M$-SQL they at least didn't invent it. ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate