>Is it possible to do something like:>> select 1 as a, a*a;>>in postgres?
Perhaps on this way:
SELECT a, a*a FROM (SELECT 1 AS a);
Greetings....