Skip site navigation (1) Skip section navigation (2)

BUG #3807: SQL : select like statement

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 (view raw or flat)
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.

pgsql-bugs by date

Next:From: Reece HartDate: 2007-12-07 02:01:38
Subject: Re: BUG #3801: max_fsm_pages postgresql.conf default !=guc.c default
Previous:From: Ted WenDate: 2007-12-06 23:21:43
Subject: BUG #3806: PreparedStatement.setString(String) throws exception

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group