Strange behaviour ( function cachable ) - Mailing list pgsql-admin

From Gaetano Mendola
Subject Strange behaviour ( function cachable )
Date
Msg-id atqh1g$2rm6$1@news.hub.org
Whole thread Raw
Responses Re: Strange behaviour ( function cachable )  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
I wrote some days ago about the behaviour that I notice
if I call a function cachable inside another not cachable,
I was wrong ?
I expected that if a function is cachable and is used
inside a select like:

SELECT * FROM foo WHERE id  = my_func( a_param )

then the function my_func is called one for each different value
of    a_param. But seems that this behaviour happen only in
stand alone query not if that query is executed inside another function.


Ciao
Gaetano




pgsql-admin by date:

Previous
From: "King_Henree@yahoo.com"
Date:
Subject: PostgeSQL equivalent to Oracle RAW column type???
Next
From: Tom Lane
Date:
Subject: Re: Strange behaviour ( function cachable )