Re: [HACKERS] equivalence class not working?

2006-01-18 Thread Simon Riggs
On Mon, 2006-01-16 at 19:03 -0500, uwcssa wrote: Fine. The rest documentation says: For now, the test only uses restriction clauses (those in restrictinfo_list). --Nels, Dec '92, however, I understand it as being overridden by the followup, which is:XXX as of 7.1, equivalence class info *is*

[HACKERS] equivalence class not working?

2006-01-16 Thread uwcssa
not sure if this is the right place to post... I am using postgres 8.1. In indxpath.c, it says Note: if Postgres tried to optimize queries by forming equivalenceclasses over equi-joined attributes (i.e., if it recognized that a qualification such as where a.b=c.d and a.b=5 could make use ofan

Re: [HACKERS] equivalence class not working?

2006-01-16 Thread Tom Lane
uwcssa [EMAIL PROTECTED] writes: I am using postgres 8.1. In indxpath.c, it says Note: if Postgres tried to optimize queries by forming equivalence classes over equi-joined attributes (i.e., if it recognized that aqualification such as where a.b=3Dc.d and a.b=3D5 could make use of an

Re: [HACKERS] equivalence class not working?

2006-01-16 Thread uwcssa
Fine. The rest documentation says:For now, the test only uses restriction clauses (those in restrictinfo_list). --Nels, Dec '92, however, I understand it as being overridden by the followup, which is:XXX as of 7.1, equivalence class info *is* available. Considerimproving this code as foreseen by