Home > mailing lists

to_char/to_number loses sign - Mailing list pgsql-hackers

From	Peter Eisentraut
Subject	to_char/to_number loses sign
Date	October 23, 2004 17:40:11
Msg-id	200410231540.35363.peter_e@gmx.net Whole thread Raw
Responses	Re: to_char/to_number loses sign
List	pgsql-hackers

Tree view

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/

pgsql-hackers by date:

From: Dennis Bjorklund
Date: 23 October 2004, 10:08:49
Subject: Re: timestamp with time zone a la sql99

From: Steve Crawford
Date: 24 October 2004, 01:17:03
Subject: Re: Time off

to_char/to_number loses sign - Mailing list pgsql-hackers

Previous

Next