different datatypes in index scan join

From: Erik Price <eprice(at)ptc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: different datatypes in index scan join
Date: 2003-06-23 18:08:35
Message-ID: 3EF74223.3000204@ptc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-06-23 18:10:19 Re: A creepy story about dates. How to prevent it?
Previous Message Dennis Gearon 2003-06-23 18:07:41 Re: [GENERAL] interesting PHP/MySQL thread