Richard Greenwood wrote:
I am getting an error from to_number() in PostgreSQL 8.2 that does not
occur in 8.1:
invalid input syntax for type numeric: " "
I assume that it is rejecting spaces, so I tried trimming with:
to_number(trim (both ' ' from streetnum),'999999999')
but still get the same error.
In 8.2 we no longer accept anything but valid numbers for numbers :). ""
is not a valid number.
The way around this is to change "" to NULL .
Sincerely,
Joshua D. Drake
Any suggestions?
Thanks,
Rich
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
