Please help! - Mailing list pgsql-general

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.