Re: [HACKERS] Oracle to Postgres : create type as object in Postgres

2009-05-24 Thread Ben Ali Rachid
>No, we don't have any concept of member functions.  Just create the >composite type (I'm assuming it needs to be composite) and then create >functions that take it as parameter. > >Note that because PG allows function overloading, there's no conflict >between, say, to_string(D_Temp_Element) a

Re: [HACKERS] Oracle to Postgres : create type as object in Postgres

2009-05-24 Thread Tom Lane
Ben Ali Rachid writes: > I've a Oracle type that I must translate to Postgres. This Oracle type is > like below : > CREATE OR REPLACE > type D_Temp_Element as object > ( >    MEMBER FUNCTION to_string return Varchar2, >    MEMBER FUNCTION duration return D_Interval, >    ... > ) ; > How can I d