Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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).

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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group