Hello 2013/3/13 Paolo Grifa <paolo.grifa@xxxxxxxxx>: > Hi all, > 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. There are orafce for PostgreSQL 9.2. download it from github https://github.com/orafce/orafce You can compile orafce via PGXS setup http://www.postgresql.org/docs/9.1/static/extend-pgxs.html or with postgresql source tarball http://postgres.cz/wiki/Oracle_functionality_%28en%29#Instalation > > 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...)?? some basic oracle function can be implemented with simple sql functions as wrappers PostgreSQL functions CREATE VIEW public.dual AS SELECT 'X'::varchar AS dummy; REVOKE ALL ON public.dual FROM PUBLIC; GRANT SELECT, REFERENCES ON public.dual TO PUBLIC; Regards Pavel > > Thanks a lot, > Paolo -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
