On Nov 30, 2007 5:23 PM, Chris Browne <cbbrowne@xxxxxxx> wrote: > And why is does it not suffice to do the following? I'm not saying it doesn't. I'm fine with writing it manually. I'm talking about making it easy for most users. Remember, we're not UNIX-only; like it or not, most Windows people wouldn't easily be able to script it. -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | jonah.harris@xxxxxxxxxxxxxxxx Edison, NJ 08837 | http://www.enterprisedb.com/ ---------------------------(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
