I am quite new in postgres, having experience with Oracle.
I was trying to migrate some very simple applications from Oracle and found out that some functions like TRUNC() are only available via an addon called "orafce". The problem is that it seems only available for Postgres 9.1, while we have obviously started with the latest release.
Does anybody know how to compile orafce for 9.2 or if there is any other solution to add some basic oracle functions (dual table, TRUNC, ecc...)??