Re: [GENERAL] to_number behavior change between 8.1 and 8.2

On 5/16/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: 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(t

Re: [GENERAL] to_number behavior change between 8.1 and 8.2

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),'9') but still get the same

Re: [GENERAL] to_number behavior change between 8.1 and 8.2

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),'9') but still get the same

[GENERAL] to_number behavior change between 8.1 and 8.2

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),'9') but still get the same error. Any suggestions?