Skip site navigation (1) Skip section navigation (2)

Re: plpgsql and index usage

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ryan Mahoney <ryan(at)flowlabs(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: plpgsql and index usage
Date: 2002-12-20 23:27:49
Message-ID: 25782.1040426869@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
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

Responses

pgsql-hackers by date

Next:From: Gavin SherryDate: 2002-12-21 02:29:44
Subject: Resource management in 7.4
Previous:From: Ryan MahoneyDate: 2002-12-20 22:35:19
Subject: plpgsql and index usage

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group