Postgres Pro
Downloads
Home   >   mailing lists

AW: Re: [GENERAL] is it a bug? - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: Re: [GENERAL] is it a bug?
Date
Msg-id 11C1E6749A55D411A9670001FA68796336814E@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Oracle-compatible lpad/rpad behavior  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
> 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

pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: beta testing version
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: Please advise features in 7.1 (SUMMARY)