I'm sorry Tom, you are right. Atentamente, Soluciones Integrales GIS C.A (SIGIS) Christian Gonzalez [EMAIL PROTECTED]
-----Mensaje original----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Tom Lane Enviado el: Miércoles, 18 de Abril de 2007 01:24 p.m. Para: Christian Gonzalez CC: pgsql-bugs@postgresql.org Asunto: Re: [BUGS] BUG #3236: Partitioning has problem with timestamp and timestamptz data type "Christian Gonzalez" <[EMAIL PROTECTED]> writes: > When you use timestamp and timestamptz data type for partitioning > implementation, your postgresql partitioning implementation doesen't > work fine when you make a SELECT using this columns type. Your example is a bit silly, since you created a table partitioned on logdate, then added two unrelated columns and expected the system to assume the table was partitioned on those. I suppose this is a mistake in the example, but it's not clear what the real complaint is. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que está limpio. -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que está limpio. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq