Forum OpenACS Q&A: Response to Postgres syntax requires me to run a function repeatedly?

Collapse
2: Response to Postgres syntax requires me to run a function repeatedly? (response to 1)
Posted by Don Baccus on 11/02/01 05:09 AM
Check out "iscacheable" ("iscachable"???) in the PG documentation.  This avoids the problem.  Ideally PL/pgSQL would recognize invariants when compiling and set this for you but it's not likely to happen for a long time ... meanwhile you're free to give PG hints.