Re: TIP9

Jaime Casanova wrote:

>>TIP 9: the planner will ignore your desire to choose
>>an index scan if your
>> joining column's datatypes do not match
>>
>>
>>
>
>Hi,
>
>sorry for using this list, but is not time to change
>this TIP for something more suitable to the new PG8
>capabilities?
>
>
Is this still not the case for pg8? I know it is better
about casting in general for use with int8 etc... but don't the
column datatypes still have to match?

>regards,
>Jaime Casanova
>
>_________________________________________________________
>Do You Yahoo!?
>Información de Estados Unidos y América Latina, en Yahoo! Noticias.
>Visítanos en http://noticias.espanol.yahoo.com
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL