: PostgreSQL 8.3.1 can't execute query

The following issue has been RESOLVED. 
============================================================
========== 
http://w
ww.dbmail.org/mantis/view.php?id=698 
============================================================
========== 
Reported By:                maximP
Assigned To:                paul
============================================================
========== 
Project:                    DBMail
Issue ID:                   698
Category:                   IMAP daemon
Reproducibility:            random
Severity:                   minor
Priority:                   normal
Status:                     resolved
target:                      
Resolution:                 fixed
Fixed in Version:           2.2.11
============================================================
========== 
Date Submitted:             13-May-08 08:04 CEST
Last Modified:              14-Jul-08 11:01 CEST
============================================================
========== 
Summary:                    PostgreSQL 8.3.1 can't execute
query
Description: 
During some user's IMAP activity, dbmail writes to log:

Error:[sql] dbpgsql.c,db_query(+287): query failed [SELECT
message_idnr
FROM dbmail_messages m JOIN dbmail_physmessage p ON
m.physmessage_id=p.id
JOIN dbmail_datefield d ON d.physmessage_id=p.id WHERE
mailbox_idnr= 210
AND status IN (0,1) AND TO_DATE(datefield,'YYYY-MM-DD')
<
TO_DATE('2008-04-29 00:00:00',
'YYYY-MM-DD') ORDER BY message_idnr]
 : [ERROR:  function to_date(timestamp without time zone,
unknown) not
exists LINE 1: ...d WHERE mailbox_idnr= 210 AND status IN
(0,1) AND
TO_DATE(da...                                               
             
^ HINT:  No function matches the given name and argument
types. You might
need to add explicit type casts. ]

Why do we need such cast: TO_DATE(datefield,'YYYY-MM-DD') ?
============================================================
========== 

------------------------------------------------------------
---------- 
 paul - 14-Jul-08 11:01  
------------------------------------------------------------
---------- 
applied patch by Alan Hodgson 

Issue History 
Date Modified   Username       Field                   
Change               
============================================================
========== 
13-May-08 08:04 maximP         New Issue                    
               
14-Jul-08 11:01 paul           Note Added: 0002587          
               
14-Jul-08 11:01 paul           Assigned To              
=> paul            
14-Jul-08 11:01 paul           Status                   new
=> resolved     
14-Jul-08 11:01 paul           Resolution               open
=> fixed       
14-Jul-08 11:01 paul           Fixed in Version         
=> 2.2.11          
============================================================
==========

_______________________________________________
Dbmail-dev mailing list
Dbmail-devdbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev