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

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!         

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

View raw message