Re: [GENERAL] Using column aliasses in the same query

2011-04-17 Thread Robert J.C. Ivens
On 17 apr 2011, at 13:43, pasman pasmaƄski wrote: > Maybe you think about WITH queries? > > 2011/4/17, Robert J.C. Ivens : >> >> On 17 apr 2011, at 13:21, Leif Biberg Kristensen wrote: >> >>> On Sunday 17 April 2011 13:01:45 Robert J.C. Ivens wrote: >&g

Re: [GENERAL] Using column aliasses in the same query

2011-04-17 Thread Robert J.C. Ivens
On 17 apr 2011, at 13:21, Leif Biberg Kristensen wrote: > On Sunday 17 April 2011 13:01:45 Robert J.C. Ivens wrote: >> Hi, >> >> I am not sure if there ever was a feature request for using defined column >> aliases in the rest of a query. This would make queries with

[GENERAL] Using column aliasses in the same query

2011-04-17 Thread Robert J.C. Ivens
Hi, I am not sure if there ever was a feature request for using defined column aliases in the rest of a query. This would make queries with a lot of logic in those aliased columns a lot smaller and this easier to write/debug. I already know you can use the following syntax: SELECT col1, col2,