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'

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