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.