"Guy Rouillier" <guyr@xxxxxxxxxxx> writes:
> Tino Wildenhain wrote:
> >
> > experiment=# SELECT 'a '::char = 'a '::char;
> > ?column?
> > ----------
> > t
> >
>
> This does't show anything useful, because the ::char casting simply
> takes the first char of any string:
>
> select 'abc'::char = 'axy'::char
>
> Also results in 'true'. Hopefully no one in this discussion would want
> those two strings to be equal.
A better experiment:
db=> select 'a '::char(3) = 'a '::char(3);
?column?
----------
t
(1 row)
--
greg
---------------------------(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
