Re: [HACKERS] 'a' == 'a ' (Was: RE: [pgsql-advocacy]

Am Mittwoch, den 19.10.2005, 22:04 +0200 schrieb Tino Wildenhain:
> Am Mittwoch, den 19.10.2005, 16:29 -0300 schrieb Marc G. Fournier:
> > I'm CC'ng this over to -hackers ... Tom? Comments?
> >
> ...

> > >> Then we are broken too :)
> > >>
> > >> # select 'a ' = 'a ';
> > >> ?column?
> > >> ----------
> > >> f
> > >> (1 row)
>
>
> experiment=# SELECT 'a '::char = 'a '::char;
> ?column?
> ----------
> t
>
Sorry, copied wrong line :)

experiment=# SELECT 'a '::char(10) = 'a '::char(10);
?column?
----------
t

and:

SELECT '|' || 'foo '::char(10) || '|';
?column?
----------
|foo|

vs.

SELECT '|' || 'foo ' || '|';
?column?
----------
|foo |