Re: [GENERAL] different datatypes in index scan join

2003-06-23 Thread Richard Huxton
On Monday 23 Jun 2003 10:06 pm, Jonathan Bartlett wrote: > Is there a link to some of these discussions? Go to http://archives.postgresql.org/ and search for "coercion" or "implicit coercion" or "implicit cast" or similar on the hackers list. -- Richard Huxton ---(end

Re: [GENERAL] different datatypes in index scan join

2003-06-23 Thread Richard Huxton
On Monday 23 Jun 2003 7:08 pm, Erik Price wrote: > 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