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.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
