[HACKERS] TIP9

2005-01-21 Thread Jaime Casanova
 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?

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 [EMAIL PROTECTED])


Re: [HACKERS] TIP9

2005-01-21 Thread Joshua D. Drake
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 [EMAIL PROTECTED])
 


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
begin:vcard
fn:Joshua Drake
n:Drake;Joshua
org:Command Prompt, Inc.
adr:;;PO Box 215 ;Cascade Locks;OR;97014;US
email;internet:[EMAIL PROTECTED]
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
x-mozilla-html:FALSE
url:http://www.commandprompt.com
version:2.1
end:vcard


---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


Re: [HACKERS] TIP9

2005-01-21 Thread Jaime Casanova
 --- Joshua D. Drake [EMAIL PROTECTED]
escribió: 
 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?
 
http://archives.postgresql.org/pgsql-hackers/2004-11/msg00497.php
???
 
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 7: don't forget to increase your free space map settings