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 wrote: >

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 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 immutable. >> In my interface it was really slow

Re: [GENERAL] Immutable function with bind value

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

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 a

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

[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