Ryan Mahoney <ryan(at)flowlabs(dot)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.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Gavin Sherry||Date: 2002-12-21 02:29:44|
|Subject: Resource management in 7.4|
|Previous:||From: Ryan Mahoney||Date: 2002-12-20 22:35:19|
|Subject: plpgsql and index usage|