Request a Demo
Home   >   mailing lists

AW: [HACKERS] Re: is it a bug? - Mailing list pgsql-general

From Zeugswetter Andreas SB
Subject AW: [HACKERS] Re: is it a bug?
Date
Msg-id 11C1E6749A55D411A9670001FA68796336814E@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Oracle-compatible lpad/rpad behavior
List pgsql-general
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-general by date:

Previous
From: Bernie Huang
Date:
Subject: Re: a script that queries db periodically
Next
From: Jason
Date:
Subject: Re: [PHP-DB] Re: [SQL] a script that queries database periodically