Re: [PERFORM] cacheable stored functions?

2004-02-20 Thread Stephan Szabo
On Fri, 20 Feb 2004, Bill Moran wrote: I'm converting a SQL application to PostgreSQL. The majority of the logic in this application is in the stored functions in the database. Somewhere, I saw a reference to WITH (iscachable) for stored functions, looking again, I'm unable to find any

Re: [PERFORM] cacheable stored functions?

2004-02-20 Thread Tomasz Myrta
Dnia 2004-02-20 16:35, Uytkownik Bill Moran napisa: Can anyone say whether this is a supported feature in plpgsql, and is safe to use? Is it simply undocumented, or am I just looking in the wrong place? iscachable is only for backward compatibility - it's changed now to IMMUTABLE You can read

Re: [PERFORM] cacheable stored functions?

2004-02-20 Thread Richard Huxton
On Friday 20 February 2004 15:35, Bill Moran wrote: I'm converting a SQL application to PostgreSQL. The majority of the logic in this application is in the stored functions in the database. Somewhere, I saw a reference to WITH (iscachable) for stored functions, looking again, I'm unable to

Re: [PERFORM] cacheable stored functions?

2004-02-20 Thread Bill Moran
Richard Huxton wrote: On Friday 20 February 2004 15:35, Bill Moran wrote: I'm converting a SQL application to PostgreSQL. The majority of the logic in this application is in the stored functions in the database. Somewhere, I saw a reference to WITH (iscachable) for stored functions, looking