different datatypes in index scan join - Mailing list pgsql-general

From Erik Price
Subject different datatypes in index scan join
Date
Msg-id 3EF74223.3000204@ptc.com
Whole thread Raw
Responses Re: different datatypes in index scan join  (Richard Huxton <dev@archonet.com>)
List pgsql-general
At the bottom of an email from this list, I saw:

 > -------------------------(end of broadcast)-------------------------
 > TIP 9: the planner will ignore your desire to choose an index scan
 > if your joining column's datatypes do not match

If that's so, then what is the recommended way to ensure an index is
used if we want to join on different datatypes?




Erik


pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: A creepy story about dates. How to prevent it?
Next
From: nolan@celery.tssi.com
Date:
Subject: MySQL/PG search times