You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by anon permutation <an...@hotmail.com> on 2003/10/15 12:27:56 UTC
torque 3.1 incompatibility with PostgreSQL
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