#1496: pgsql fails with timestamp comparisons
------------------------------+---------------------------------------------
Reporter: Russ | Owner: romanb
Type: defect | Status: closed
Priority: major | Milestone:
Component: Query/Hydration | Version: Trunk
Resolution: invalid | Keywords: pgsq postgresql timestamp
Has_test: 0 | Mystatus: Pending Core Response
Has_patch: 0 |
------------------------------+---------------------------------------------
Changes (by jwage):
* status: new => closed
* resolution: => invalid
Comment:
This ticket is a problem with sfDoctrineGuardPlugin so it is not a problem
with Doctrine. Lets move this ticket to the symfony trac. You can copy my
response below there:
----------
I think the issues is that `created_at` is a date formatted like `YYYY-MM-
DD HH:MM:SS` and
{{{
->where('created_at < ?', time() - $expiration_age)
}}}
is not working for any dbms but postgres yields an error and mysql does
not. But the query isn't actually returning the appropriate results for
Doctrine. Create the ticket in symfony and we'll get it fixed.
--
Ticket URL: <http://trac.doctrine-project.org/ticket/1496#comment:1>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"doctrine-svn" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.co.uk/group/doctrine-svn?hl=en-GB
-~----------~----~----~----~------~----~------~--~---
