Oracle to Postgres : create type as object in Postgres
От | Ben Ali Rachid |
---|---|
Тема | Oracle to Postgres : create type as object in Postgres |
Дата | |
Msg-id | 553023.14921.qm@web28507.mail.ukl.yahoo.com обсуждение исходный текст |
Ответы |
Re: Oracle to Postgres : create type as object in Postgres
|
Список | 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 по дате отправления: