Forum OpenACS Development: Response to Porting pl/pgsql using PERFORM and SELECT to call functions

There are (at least) 3 ways to call a function from within another function in plpgsql.

1) v_foo := my_func();
2) select my_func() into v_foo;
3) perform my_func();

The only difference between a select and a perform is that perform doesn't capture the return value. Also, it should be noted that perform is a plgpsql-only thing - it won't work outside of a stored-procedure block.

Just calling 'my_func()' will work in oracle, but in pg you need to stick a 'perform' in front of it