Horton

to_char/to_number loses sign

Peter Eisentraut <peter_e@gmx.net>

View thread
From: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-hackers@postgresql.org
Date: 2004-10-23T13:40:35Z
Lists: pgsql-hackers 
This is from one of the examples in the documentation:

SELECT to_char(-485, '999S');
 to_char
---------
 485-

The reverse doesn't work as well:

SEKLECT to_number('485-', '999S');
 to_number
-----------
       485

Is this a bug or intentional?

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/