Please help!

Hi,

I have a registration database. I need to know number of
registrations / month in a report format. How will I get a report like
this ?

In Oracle I can give the query like this:-
"select to_char(reg_date, 'Mon yyyy'), count(*) from
register group by to_char(reg_date, 'Mon yyyy') order by
to_date(to_char(reg_date, 'Mon yyyy'), 'Mon yyyy');"

When I tried in psql, it gave this error. "No such function
'to_char' with the specified attributes". But in postgre there is a
function called to_char(). Then why am I getting this error? My postgre
version is "PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc
egcs-2.91.66".

Please help.

Thanks in advance,

Vijayan.