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.
Any suggestions?
I seem to recall it was tightened up - you'll need to give it a valid
number. What number is '' supposed to be?
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
