Re: orafce

Hello

2013/3/13 Paolo Grifa <paolo(dot)grifa(at)gmail(dot)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