On Sat, Aug 27, 2011 at 7:43 AM, Dean Rasheed <dean.a.rash...@gmail.com> wrote: > On 27 August 2011 12:29, Dean Rasheed <dean.a.rash...@gmail.com> wrote: >> ... if nothing else it has been a >> fun exercise figuring out how the datetime string parsing code works. > > While looking through the current code, I spotted the following oddity: > > select timestamp 'yesterday 10:30'; > timestamp > --------------------- > 2011-08-26 10:30:00 > > which is what you'd expect, however: > > select timestamp '10:30 yesterday'; > timestamp > --------------------- > 2011-08-26 00:00:00 > > Similarly "today" and "tomorrow" reset any time fields so far, but > ISTM that they should really be preserving the hour, min, sec fields > decoded so far.
Sounds right to me. Want to send a patch? BTW, this is exactly the sort of thing that makes me a bit skeptical about further extending this... -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
