On Fri, Jan 15, 2010 at 9:38 AM, Kevin Grittner <kevin.gritt...@wicourts.gov> wrote: > "Jodi Escalante" <jescala...@assistgroup.com> wrote: > >> INSERT INTO assessment (id, created, taken, current_weight, note, >> assessment_type, stay_id, contact_id, estimated_discharge_date, >> cond_chf, cond_pulm_heart, cond_endocrine_other, cond_skin_temp, >> ) VALUES ( 50, 2008-01-11 15:06:40.257000 -07:00:00, >> 2008-01-11 00:00:00.000000 -07:00:00, 2000.0, NULL, Initial, >> 3452, 2147, NULL, N, N, N, N) > > Without quotes you've got the calculation (2008 minus 1 minus 11) > which equals the integer 1996. It doesn't know what to make of the > number which comes next. Try something like TIMESTAMP WITH TIME > ZONE '2008-01-11 15:06:40.257000 -0700'. Similar issues seem to > exist with most of your other literals.
Just as a note this might have appeared to work in pre-8.3 but may have done the wrong thing. Definitely quote your literals. Best Wishes, Chris Travers -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
