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

The Error code is asfollows

[27/Dec/2000:15:14:13] Error: Ns_PgExec: result status: 7 message: ERROR: Function 'decode(timestamp, timestamp, unknown, unknown)' does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts [27/Dec/2000:15:14:13] Error: dbinit: error(localhost::iigfdb,ERROR: Function 'decode(timestamp, timestamp, unknown, unknown)' does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts ): 'select classified_ad_id, one_line, primary_category,posted, last_modified as edited_date, originating_ip, users.user_id, email as poster_email, decode(last_modified, posted, 'f', 't') as ever_edited_p from classified_ads, users where domain_id = 1 and users.user_id = classified_ads.user_id and (sysdate <= expires or expires is null) order by classified_ad_id desc' [27/Dec/2000:15:14:13] Error: Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.") Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.") while executing "ns_db select $db "select classified_ad_id, one_line, primary_category,posted, last_modified as edited_date, originating_ip, users.user_id, email as po ..." invoked from within "set selection [ns_db select $db "select classified_ad_id, one_line, primary_category,posted, last_modified as edited_date, originating_ip, users.user_ ..." (file "/web/iig.org.in/www/gc/admin/ads.tcl" line 45) invoked from within "source $script" invoked from within "if ![file exists $script] { ns_returnnotfound $conn } else { source $script }" (procedure "ns_sourceproc" line 3) invoked from within "ns_sourceproc cns173 {}" Notice: dbdrv: opening database 'postgres:localhost::iigfd

I think the function decode is not supported. Nothing More. Can someone help it to debug.

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

Thanks was able to fix it