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 |
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
