"Dann Corbit" <[EMAIL PROTECTED]> 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
