AW: [HACKERS] is it a bug?

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'Thomas Lockhart'" <lockhart(at)alumni(dot)caltech(dot)edu>, He weiping <laser(at)zhengmai(dot)com(dot)cn>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: AW: [HACKERS] is it a bug?
Date: 2000-11-28 14:40:15
Message-ID: 11C1E6749A55D411A9670001FA68796336814D@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


> > ... it seems the "lpad", "rpad" don't work,
> > when I type:
> > select lpad('laser', 4, 'a');
> > in psql, the result is still
> > 'laser', the same with 'rpad',
> > Is it a bug or I'm mis-understaning the lpad and/or rpad functions?
>
> A simple misunderstanding. The length argument is for the *total*
> length. So padding a 5 character string to a length of 4 will do
> nothing. But padding to a length of 6 will add a single "a" to the
> string.

Seems the implementor made a mistake, since this is supposed to be oracle
compat stuff it should behave like Oracle, and thus trim the string to 4 chars.

Andreas

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Lockhart 2000-11-28 14:48:21 Re: [HACKERS] is it a bug?
Previous Message Gordan Bobic 2000-11-28 13:56:11 Re: Tuple size limits and upgrading

Browse pgsql-hackers by date

  From Date Subject
Next Message Don Baccus 2000-11-28 14:41:53 RE: Full text Indexing -out of contrib and into main..
Previous Message Don Baccus 2000-11-28 14:37:52 Re: beta testing version