Thread: IMMUTABLE?
View Single Post

   
  #10 (permalink)  
Old 04-19-2008, 07:48 AM
David Wheeler
 
Posts: n/a
Default Re: IMMUTABLE?

On May 16, 2006, at 18:29, Christopher Kings-Lynne wrote:

>> Yes, but there are definitely programming cases where memoization/
>> caching definitely helps. And it's easy to tell for a given
>> function whether or not it really helps by simply trying it with
>> CACHED and without.
>> Would this be a simple thing to implement?

>
> It's called a "table"


http://www.justatheory.com/computers...es/postgresql/
higher_order_plpgsql.html

Yes, I know. :-P But it'd be easier to have a CACHED keyword, of course.

Best,

David

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Reply With Quote