Forum OpenACS Q&A: Response to Converting some code from

1) I don't see anything tricky here.  Should be easy to do with PG triggers or rules.  What in particular is causing problems?

2) "decode" is an oracleism, use "case when" instead.

3) the (+) notation for outer joins is another oraclism.  use "left outer join" instead.

Re the argument limitation, I'm not sure what the standard workaround is but pg 7.3 is in beta2 and supports 32 args per function.