Re: [HACKERS] Re: [GENERAL] Oracle-compatible lpad/rpad behavior

2000-12-12 Thread Hannu Krosing
Jonathan Ellis wrote: I went to fix this and then realized I still don't have an adequate spec of how Oracle defines these functions. It would seem logical, for example, that lpad might truncate on the left instead of the right, ie lpad('abcd', 3, 'whatever') might yield 'bcd' not

Re: [GENERAL] Oracle-compatible lpad/rpad behavior

2000-12-07 Thread Jonathan Ellis
I went to fix this and then realized I still don't have an adequate spec of how Oracle defines these functions. It would seem logical, for example, that lpad might truncate on the left instead of the right, ie lpad('abcd', 3, 'whatever') might yield 'bcd' not 'abc'. Would someone check?