On Tue, 20 Mar 2012 10:46:31 -0000, "nathanelrick" <nathanelrick@...>
wrote:

> it's a bad new that i have no way :(
>
> when i try the CTE, the prepare seam to grow ("seam" i just do now some
> tests). also CTE are a little hard to use in my situation ...

The use an inner select / subquery:

SELECT
<whatever special logic you need>
FROM (SELECT <the fields you need and their aliases> FROM yourTable) A