Re: Select aliasses in where and other places of the
От | Arjen van der Meijden |
---|---|
Тема | Re: Select aliasses in where and other places of the |
Дата | |
Msg-id | 001a01c2f6e2$9d395fe0$3ac15e91@acm обсуждение исходный текст |
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: