[BUGS] [7.3.3] select with stable function not being optimized to index scan

2003-12-11 Thread Barrie Slaymaker
Your name : Barrie Slaymaker Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : Pentium Operating System (example: Linux 2.0.26 ELF) : WinXP+cygwin PostgreSQL version (example: PostgreSQL-7.3.3

Re: [BUGS] [7.3.3] select with stable function not being optimized to index scan

2003-12-11 Thread Barrie Slaymaker
The underlying problem turned out to be using an function returning int8 on a column of type int. When the function is altered to return int, an index scan is used. On Dec 10 2003, Barrie Slaymaker wrote: Your name : Barrie Slaymaker Your email address : [EMAIL PROTECTED