Re: Reusing columns in SELECT list - Mailing list pgsql-novice

Andre Majorel <aym-lqsgp@teaser.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