From: | "" <Tani(dot)Masaki(at)bp(dot)MitsubishiElectric(dot)co(dot)jp> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #3807: SQL : select like statement |
Date: | 2007-12-07 00:05:04 |
Message-ID: | 200712070005.lB70543T024585@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 3807
Logged by:
Email address: Tani(dot)Masaki(at)bp(dot)MitsubishiElectric(dot)co(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Reece Hart | 2007-12-07 02:01:38 | Re: BUG #3801: max_fsm_pages postgresql.conf default != guc.c default |
Previous Message | Ted Wen | 2007-12-06 23:21:43 | BUG #3806: PreparedStatement.setString(String) throws exception |