"john lyssy" <[EMAIL PROTECTED]> writes:
> This cast returns:ERROR: invalid input syntax for type numeric: ""
> select string1 from adfields where
> (cast (string1 as decimal (6,2)) >= 0.0) and (string1 != '' )
Why do you find that surprising? There's nothing there to guarantee
that the string1
The following bug has been logged online:
Bug reference: 2866
Logged by: john lyssy
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: Windows XP
Description:cast varchar to decimal failure
Details:
This cast returns:ERROR: invalid input synt
