>Ryan Mahoney <[EMAIL PROTECTED]> 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 or
c. change the data type in the table
I am not familiar with the bpchar type, but I am looking into it now.
Thanks!
-r
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
