Re: Bug on CHARACTER(n) ?

From: Pawel Bernat <asm(at)asm(dot)flynet(dot)pl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug on CHARACTER(n) ?
Date: 2005-11-28 16:57:47
Message-ID: 20051128175747.A18928@vlo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Nov 28, 2005 at 05:49:02PM +0100, Stefano Reksten wrote:
> Should not a char(10) insert 6 padding spaces? Or am I missing something
> like an update in the SQL standard?
Use char_length(string).

regards
--
Paweł Bernat; uselessness' lover;
select'<asm'||chr(64)||'asm'||'.'||'flynet'||chr(46)||'pl>'as email;
Slowly and surely the unix crept up on the Nintendo user ...

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Pawel Bernat 2005-11-28 17:02:55 Re: Bug on CHARACTER(n) ?
Previous Message Stefano Reksten 2005-11-28 16:49:02 Bug on CHARACTER(n) ?