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(at)macrongolf(dot)com
http://macrongolf.com
http://eteampoint.com
http://macron.com