Re: A question on the query planner

Greg Stark wrote:

>Jared Carr <jared@89glass.com> writes:
>
>
>
>>Greg Stark wrote:
>>
>>
>>
>>>>        Merge Cond: ("outer"."?column7?" = "inner"."?column5?")
>>>>
>>>>
>>>>
>>>Well it looks like you have something strange going on. What data type is
>>>car_id in each table?
>>>
>>>
>>car_id is a varchar(10) in both tables.
>>
>>
>
>Well for some reason it's being cast to a text to do the merge.
>
>What version of postgres is this btw? The analyzes look like 7.4?
>
>
>
Yes, this is 7.4.