sum of row values..

hi all..
i have a big problem..why is this impossible in postgresql:

table test: (1 column)

first
------
1
2
3
4
5
6
7
8
9


select first as value, value*2 as result from test;

How can i accomplish this?? I need it for a very big table that will use
also functions in it..

Thanks..

fabrizio@macrongolf.com
http://macrongolf.com
http://eteampoint.com
http://macron.com