Stephane,
> > to_number works in the same fashion as in oracle. You need to give
> > to_number('<yourdata>','formatmask')
> > For example, to_number('1234567','FM9999999')
> >
> > Regards,
> > Gautham.
A list of PostgreSQL functions:
http://www7.us.postgresql.org/users-lounge/docs/7.2/postgres/functions.html
-Josh