Adam Haberlach <adam@newsnipple.com> writes:
> ... one of the engineers has been writing some queries that
> cast a text field to an int and take advantage of the
> fact that we used to turn text fields with no digits into 0,
> much as C's atoi function works.
> The new behavior is to throw a parse error, which causes
> all kinds of problem. Is this intentional?
What new behavior?
regression=# select ''::text::int4;?column?
---------- 0
(1 row)
7.0.* behaves the same as far as I can tell. I think this is actually
a bug, and it *should* throw an error ... but it doesn't.
regards, tom lane
