On 2012-04-24, rihad <rihad@xxxxxxx> wrote: > As PostgreSQL stores timestamps with a fractional part, does it mean that > WHERE f BETWEEN '2012-04-23 00:00:00' AND '2012-04-23 23:59:59' might miss > records with values of f equal to 23:59:59.1234 or so? yes, it does. BETWEEN doesn't work well for timestamps. you have to do it the long way f >= '2012-04-23 00:00:00' AND f < '2012-04-24 00:00:00' -- ⚂⚃ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
