"Dann Corbit" <DCorbit@xxxxxxxxx> writes:
> Would you want varchar(30) 'Dann Corbit' to compare equal to bpchar(30)
> 'Dann Corbit'?
> I would.
And your point is?
regression=# select varchar(30) 'Dann Corbit' = char(30) 'Dann Corbit';
?column?
----------
t
(1 row)
regards, tom lane
---------------------------(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
