> lpad and rpad never truncate, they only pad. > > Perhaps they *should* truncate if the specified length is less than > the original string length. Does Oracle do that? Yes, it truncates, same as Informix. Andreas
- [HACKERS] Oracle-compatible lpad/rpad behavior Zeugswetter Andreas SB
- [HACKERS] Oracle-compatible lpad/rpad behavior Tom Lane
- Re: [GENERAL] Oracle-compatible lpad/rpad ... Jonathan Ellis
- Re: [HACKERS] Re: [GENERAL] Oracle-com... Hannu Krosing