[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

[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

Re: [GENERAL] Immutable function with bind value

2012-01-20 Thread Brice Maron
avoid using bind for those queries but i didn't like it Cheers, Brice On Fri, Jan 20, 2012 at 15:28, Matteo Beccati p...@beccati.com wrote: On 20/01/2012 12:43, Brice Maron wrote: Hi, i've discovered something kind of weird  while developing my app... I was trying to fetch some records

Re: [GENERAL] Immutable function with bind value

2012-01-20 Thread Brice Maron
On Fri, Jan 20, 2012 at 16:00, David Johnston pol...@yahoo.com wrote: On Jan 20, 2012, at 6:15, Brice Maron bma...@gmail.com 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 immutable. In my