Hello
2013/3/13 Paolo Grifa <paolo.grifa@gmail.com>:
> 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