Re: Select aliasses in where and other places of the

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(at)cvc(dot)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
>