> 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.
pgsql-hackers by date
|Next:||From: Ross J. Reedstrom||Date: 2000-11-28 15:43:24|
|Subject: Re: Please advise features in 7.1 (SUMMARY)|
|Previous:||From: xuyifeng||Date: 2000-11-28 15:26:00|
|Subject: Re: beta testing version|
pgsql-general by date
|Next:||From: Hancock, David (DHANCOCK)||Date: 2000-11-28 16:02:22|
|Subject: Help with Database Recovery|
|Previous:||From: Tom Lane||Date: 2000-11-28 15:09:57|
|Subject: Re: is it a bug? |