Folks,
While debugging an error with Aziz (postgres_newbie) Sharief in the
#postgresql IRC channel, I found a major POLA violation:
$ psql
Welcome to psql 8.3.7, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g
orterminate with semicolon to execute query \q to quit
shackle@shackle:5432=# SELECT now() + '900000'; ?column?
-------------------------------2009-09-03 19:03:43.195514-07
(1 row)
shackle@shackle:5432=# SELECT now() - '900000';
ERROR: date/time field value out of range: "900000"
HINT: Perhaps you need a different "datestyle" setting.
I'd be tempted to call it a flat-out bug in the first case. Adding a
string literal to a timestamptz should just result in an error, IMHO.
Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate