Tip ?

From: Alain <alainm(at)pobox(dot)com>
To: Sql-Postgre <pgsql-sql(at)postgresql(dot)org>
Subject: Tip ?
Date: 2005-05-24 18:26:50
Message-ID: 429371EA.30502@pobox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-sql


This tip was at the end of a message (from Szűcs Gábor).

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

it looks very important, but I cannot understand it. Sound as a small
and easy mistake that can make things go sour...

Can someone explain it please?

thanks,
Alain

In response to

Responses

  • Re: Tip ? at 2005-05-24 18:34:07 from Scott Marlowe

Browse pgsql-bugs by date

  From Date Subject
Next Message Scott Marlowe 2005-05-24 18:34:07 Re: Tip ?
Previous Message Tom Lane 2005-05-24 18:12:25 Re: [SQL] could not devise a query plan

Browse pgsql-sql by date

  From Date Subject
Next Message Scott Marlowe 2005-05-24 18:34:07 Re: Tip ?
Previous Message Tony Wasson 2005-05-24 18:15:12 Re: Help: Function for splitting VARCHAR column and migrating its data to 2 new tables