Average value for Money Datatype
SELECT AVG(price::numeric) FROM pc;
or
As per PostgreSQL 8 .4's Monetary Types
select avg(regexp_replace(price::text, '[$,]', '', 'g')::numeric) from pc
SELECT AVG(price::numeric) FROM pc;
or
As per PostgreSQL 8 .4's Monetary Types
select avg(regexp_replace(price::text, '[$,]', '', 'g')::numeric) from pc