Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] [GENERAL] - Mailing list pgsql-hackers

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  |