Postgres Pro
Downloads
Home   >   mailing lists

Tip ? - Mailing list pgsql-sql

From Alain
Subject Tip ?
Date
Msg-id 429371EA.30502@pobox.com
Whole thread Raw
In response to Re: could not devise a query plan  (Szűcs Gábor <surrano@gmail.com>)
Responses Re: Tip ?  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: could not devise a query plan
Next
From: Scott Marlowe
Date:
Subject: Re: Tip ?