The following bug has been logged online: Bug reference: 3807 Logged by: Email address: Tani.Masaki@bp.MitsubishiElectric.co.jp PostgreSQL version: 8.3.0 beta4 Operating system: WindowsXP Description: SQL : select like statement Details: Why? specific change? statement: select * from CAL_M00001 where tag_idx = 1 and logdate like '2007-12%' ERROR: operator does not exist: timestamp without time zone ~~ unknown at character 56 HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. CREATE TABLE CAL_M00001( TAG_IDX DECIMAL(6) NOT NULL, LOGDATE TIMESTAMP NOT NULL, DATA DECIMAL(15,3) ); 8.0.*/8.1.*/8.2.* is OK. ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate