Re: Fixed length data types issue

Gregory Stark wrote:
> 
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> 
> > Gregory Stark wrote:
> >> 
> >> Well "char" doesn't have quite the same semantics as CHAR(1). If that's the
> >> consensus though then I can work on either fixing "char" semantics to match
> >> CHAR(1) or adding a separate type instead.
> >
> > What semantics?  
> 
> The main bit that comes to mind is 32::CHAR(1) give you '3' but 32::"char"
> gives you ' '.
> 
> Really it makes more sense if you think of "char" is a 1 byte integer type
> with some extra text casts and operators to make C programmers happy, not a 1
> byte character type.

One very nifty trick would be to fix "char" to act as CHAR(), and map
CHAR(1) automatically to "char".

--  Bruce Momjian   bruce@momjian.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +