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

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 resulti