db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "anon permutation" <anonpermutat...@hotmail.com>
Subject torque 3.1 incompatibility with PostgreSQL
Date Wed, 15 Oct 2003 10:27:56 GMT

Hi Martin,

I have encountered a problem when using Torque 3.1 with PostgreSQL, and I am 
trying to verify that this is an actual bug.

When using Torque 3.0, a select statement that uses a Timestamp column will 
be generated as something like this:

select * FROM instru_intraday
WHERE (instru_intraday.SAMPLE_DATE>{ts '2003-09-17 00:00:00.0'} AND 
instru_intraday.SAMPLE_DATE<{ts '2003-10-15 18:14:35.721'})

However, when using Torque 3.1, something like this is generated:

This (simplified) sql statement is generated:
SELECT * FROM instru_intraday WHERE
(instru_intraday.SAMPLE_DATE>'20030916000000' AND
instru_intraday.SAMPLE_DATE<'20030918152213')

PostgreSQL will complain about --  Bad timestamp external
representation '20030916000000'

Have you seen something like this?  Thanks.

_________________________________________________________________
Concerned that messages may bounce because your Hotmail account has exceeded 
its 2MB storage limit? Get Hotmail Extra Storage!         
http://join.msn.com/?PAGE=features/es


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message