>Ryan Mahoney <ryan@flowlabs.com> writes:
>> Index Scan using pa_zipcode_proximity_pk on pa_zipcode_proximity (cost=
>> 0.00..13.53 rows=3 width=862)
>> Index Cond: ((zipcode = '11103'::bpchar) AND (proximity <= 100))
>> (183 rows)
>
>Hmm ... evidently zipcode is declared as type char(5) (note the "bpchar"
>coercion). Is the plpgsql variable it's being compared to declared the
>same way? This could be ye olde cross-datatype-coercion problem.
Interesting! I think in plpgsql the data type of the argument coming
in to the function is "text". Are you suggesting that I:a. use a different datatype in plpgsql or b. cast the values
orc.change the data type in the table
I am not familiar with the bpchar type, but I am looking into it now.
Thanks!
-r