Afaik they don't work in MySQL.
Perhaps in the brand new 4.x series, but at least not in the 3.23
versions.
Arjen
> -----Oorspronkelijk bericht-----
> Van: Dennis Gearon [mailto:gearond@cvc.net]
> Verzonden: zondag 30 maart 2003 18:59
> Aan: Arjen van der Meijden
> Onderwerp: Re: [GENERAL] Select aliasses in where and other
> places of the selectlist?
>
>
> Those are supported by mysql, so I don't think they're
> difficult. Anything previously determined in a query
> statement can be used as a value in later parts of a statement.
>
> Arjen van der Meijden wrote:
> >
> > Hi List,
> >
> > I know it isn't possible to do queries like:
> > SELECT 1 AS c, c + 1 AS d;
> >
> > Other queries that aren't possible are those:
> > SELECT intfield AS a, intfield * intfield AS square FROM
> tableX WHERE
> > a < 10 AND square < 50
> >
> > Of course, these are bogus examples to simply illustrate my
> point :)
> > But is there a good reason not to support it or is it
> something like
> > "not yet implemented", "not interesting" or "to complex to (easily)
> > implement".
> >
> > Best regards,
> >
> > Arjen
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faqs/FAQ.html
>
