Adam Gundy <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Oh, it coerces the type all right, just not in the direction you'd like.
> is there a reason it doesn't coerce to a type that's useful to the > planner (ie varchar in my case), In this case I think the choice is probably semantically correct: shouldn't a comparison of varchar (trailing space sensitive) and char (trailing space INsensitive) follow trailing-space-insensitive semantics? I wouldn't swear that the behavior is intentional ;-) as to going that way rather than the other, but I'm disinclined to change it. > or the planner doesn't accept any type > of string as a valid match for index scan? Can't. This equality operator doesn't have the same notion of equality that that index does. The long and the short of it is that mixing char and varchar is hazardous. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance