Re: [PERFORM] Problems using a function in a where clause

2006-10-25 Thread Jim C. Nasby
On Wed, Oct 25, 2006 at 07:55:38AM -0300, Mara Dalponte wrote: On 10/24/06, Jim C. Nasby [EMAIL PROTECTED] wrote: On Mon, Oct 23, 2006 at 04:54:00PM -0300, Mara Dalponte wrote: Hello, I have a query with several join operations and applying the same filter condition over each involved

Re: [PERFORM] Problems using a function in a where clause

2006-10-24 Thread Jim C. Nasby
On Mon, Oct 23, 2006 at 04:54:00PM -0300, Mara Dalponte wrote: Hello, I have a query with several join operations and applying the same filter condition over each involved table. This condition is a complex predicate over an indexed timestamp field, depending on some parameters. To

[PERFORM] Problems using a function in a where clause

2006-10-23 Thread Mara Dalponte
Hello, I have a query with several join operations and applying the same filter condition over each involved table. This condition is a complex predicate over an indexed timestamp field, depending on some parameters. To factorize code, I wrote the filter into a plpgsql function, but the