Re: [GENERAL] Immutable function with bind value

2012-01-20 Thread Brice Maron
On Fri, Jan 20, 2012 at 16:00, David Johnston wrote: > On Jan 20, 2012, at 6:15, Brice Maron wrote: > >> Hi, >> >> i've discovered something kind of weird  while developing my app... >> I was trying to fetch some records in a table using a function immutabl

Re: [GENERAL] Immutable function with bind value

2012-01-20 Thread Brice Maron
le('var')) for now i've avoid using bind for those queries but i didn't like it Cheers, Brice On Fri, Jan 20, 2012 at 15:28, Matteo Beccati wrote: > On 20/01/2012 12:43, Brice Maron wrote: >> Hi, >> >> i've discovered something kind of weird

[GENERAL] Immutable function with bind value

2012-01-20 Thread Brice Maron
Hi, i've discovered something kind of weird while developing my app... I was trying to fetch some records in a table using a function immutable. In my interface it was really slow and while i was in a psql it was really fast ... After some research i've found out that it was caused by the bind p

[GENERAL] Immutable function with bind value

2012-01-20 Thread Brice Maron
Hi, i've discovered something kind of weird  while developing my app... I was trying to fetch some records in a table using a function immutable. In my interface it was really slow and while i was in a psql it was really fast ... After some research i've found out that it was caused by the bind p