Christoph Zwerschke wrote:
> Am 26.04.2010 12:11, schrieb Takahiro Itagaki:
>> Do you know how the SQL standard mention the behavior? IMHO,
>> postgres' behavior is more reasonable because
>> length(' '::char(1)) is 0.
>
> Just found http://troels.arvin.dk/db/rdbms/ which claims that this
> is
Am 26.04.2010 12:11, schrieb Takahiro Itagaki:
> The problem is not in ascii(), but in casting from char to text.
> We have only one version of ascii() in default; ascii(text).
> So, if you use ascii( ' '::char(1) ), it is actually handled as
> ascii( ' '::char(1)::text ). Traling spaces were remov
"Christoph Zwerschke" wrote:
>ascii(cast(' ' as char(1))),
>ascii(cast(' ' as char))
> both give 0.
>
> I think this quirk should be fixed or at least mentioned in the
> documentation of ascii().
The problem is not in ascii(), but in casting from char to text.
We have only one version
The following bug has been logged online:
Bug reference: 5438
Logged by: Christoph Zwerschke
Email address: c...@online.de
PostgreSQL version: 8.0-8.4
Operating system: all
Description:Bug/quirk in ascii() function
Details:
As you would expect,
ascii(cast(' ' as
