Re: to_char/to_number loses sign

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Karel Zak <zakkr@zf.jcu.cz>
Cc: Peter Eisentraut <peter_e@gmx.net>, List pgsql-hackers <pgsql-hackers@postgreSQL.org>
Date: 2004-10-26T17:27:24Z
Lists: pgsql-hackers
Karel Zak <zakkr@zf.jcu.cz> writes:
> Yes, you're right. It strange, but NUM_S missing there. The conversion
> from string to number is less stable part of formatting.c...

> The patch is in the attachment.

This patch causes the regression tests to fail.  I think you need to
consider the to_char() side of it more carefully.

			regards, tom lane