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