[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 Matteo Beccati
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 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

Re: [GENERAL] Immutable function with bind value

2012-01-20 Thread Brice Maron
Thanks Matteo for your answer... but.. this is only a usecase... i'm currently using thing like this in a php app, so i'm doing kind of a as select * from test where a = test_immutable(?); then execute('var'); unfortunately there, i can't to an execute(test_immutable('var')) for now i've

Re: [GENERAL] Immutable function with bind value

2012-01-20 Thread David Johnston
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 interface it was really slow and while i was in a psql it was really fast

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

Re: [GENERAL] Immutable function with bind value

2012-01-20 Thread David Johnston
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Brice Maron Sent: Friday, January 20, 2012 1:26 PM To: David Johnston Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Immutable function with bind value On Fri, Jan

Re: [GENERAL] Immutable function with bind value

2012-01-20 Thread Misa Simic
parametar of an function is safe enough... Kind Regards, Misa Sent from my Windows Phone From: Brice Maron Sent: 20/01/2012 19:28 To: David Johnston Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Immutable function with bind value On Fri, Jan 20, 2012 at 16:00, David Johnston pol