On 7/29/16 3:13 PM, David Fetter wrote: > I expect this kind of blather from MySQL, but you've brought up > something that's been bothering me for awhile. PostgreSQL's response > should look more like this: > > ERROR: month field value out of range: "2016-99-99" > LINE 1: select cast('2016-99-99' as date); > ^ > Any idea how much effort that would be?
This particular case is probably not hard, but the problem is that that would raise the bar about error pointer precision, and you then should also update a bunch of other places to give similar precision. That could be a lot of work. I am, however, of the opinion, that these kinds of things can never be helpful enough. The latest trend is start and end pointers, which would be nice. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers