Andre Majorel <aym-lqsgp(at)teaser(dot)fr> writes:
> Is there a way to reuse in the SELECT list columns defined earlier
> in it ?
No.
You can use multiple levels of select:
select xy, xy + xy from (select x * y as xy from a,b) ss;
but this is not likely to save any computation, just typing.
regards, tom lane