Oracle to Postgres : create type as object in Postgres - Mailing list pgsql-hackers

From Ben Ali Rachid
Subject Oracle to Postgres : create type as object in Postgres
Date
Msg-id 553023.14921.qm@web28507.mail.ukl.yahoo.com
Whole thread Raw
Responses Re: Oracle to Postgres : create type as object in Postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
<table border="0" cellpadding="0" cellspacing="0"><tr><td style="font: inherit;" valign="top">Hello, <br /><br />I've a
Oracletype that I must translate to Postgres. This Oracle type is like below :<br /><br /><span style="font-style:
italic;">CREATEOR REPLACE</span><br style="font-style: italic;" /><span style="font-style: italic;">type D_Temp_Element
asobject</span><br style="font-style: italic;" /><span style="font-style: italic;">(</span><br style="font-style:
italic;"/><span style="font-style: italic;">   MEMBER FUNCTION to_string return Varchar2,</span><br style="font-style:
italic;"/><span style="font-style: italic;">   MEMBER FUNCTION duration return D_Interval,</span><br style="font-style:
italic;"/><span style="font-style: italic;">   ...</span><br style="font-style: italic;" /><span style="font-style:
italic;">);</span><br style="font-style: italic;" /><br />How can I do that in Postgres ? Is there something that be
equivalent?<br />Thanks.<br /><br />Rachid<br /></td></tr></table><br /> 

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: generic options for explain
Next
From: Alvaro Herrera
Date:
Subject: Re: pull raw text of a message by message-id