to_number behavior change between 8.1 and 8.2

From: "Richard Greenwood" <richard(dot)greenwood(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: to_number behavior change between 8.1 and 8.2
Date: 2007-05-16 17:56:53
Message-ID: ae9185aa0705161056l60d25a43oa9574df606b5bad@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks,
Rich

--
Richard Greenwood
richard(dot)greenwood(at)gmail(dot)com
www.greenwoodmap.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-05-16 18:02:36 Re: to_number behavior change between 8.1 and 8.2
Previous Message Andrus 2007-05-16 17:51:22 Re: How to implement GOMONTH function