Re: [GENERAL] Nested IMMUTABLE functions

2008-06-14 Thread Joris Dobbelsteen
Peter wrote: I have two immutable Pl/PG funcs - func A takes a parameter X, looks up related value Y from a table and passes Y to func B. Now, if I do something like select A(field_x) from bigtable it will, of course call A for every single row since paramater is changing. However, it also call

[GENERAL] Nested IMMUTABLE functions

2008-06-12 Thread Peter
I have two immutable Pl/PG funcs - func A takes a parameter X, looks up related value Y from a table and passes Y to func B. Now, if I do something like select A(field_x) from bigtable it will, of course call A for every single row since paramater is changing. However, it also calls func B for ev