Thread

Re: [HACKERS] translate function (BUG?)

Keith Parks <emkxp01@mtcc.demon.co.uk> — 1999-11-13T17:15:28Z

What happened with this?

I think I saw a response from Bruce but it wasn't fixed and
doesn't appear in the current CVS of V7.

Keith.

>From: Edwin Ramirez <ramirez@doc.mssm.edu>
>Hello all,
>
>I was looking at the translate function and I think that it does not
>behave quite right.  I modified the translate function in
>oracle_compat.c (included below) to make work more like its Oracle
>counterpart. It seems to work but it returns the following message:
>	NOTICE:  PortalHeapMemoryFree: 0x8241fcc not in alloc set!
>
>Below are the Oracle and Postgres session transcripts.  
>
>select translate('edwin', 'wi', 'af') from dual;
>ORACLE:
>TRANS
>-----
>edafn
>1 row selected.
>
>POSTGRES
>translate
>---------
>edain    
>(1 row)

<snip>