Forum OpenACS Q&A: Response to error in "gc/admin/ads.tcl?domain_id=1&num_days=all"

decode is oracle's proprietery version of a 'case when' statement.  This must have been missed in our porting efforts.  You can fix this by changing the decode statement to:

case when last_modified = posted then 'f'::char else 't'::char end as ever_edited_p