W dniu 30/03/2016 o 18:03, David G. Johnston pisze:
I propose for TEXT cast '-0'::FLOAT and '+0'::FLOAT to '0'::TEXT - like '-0'::NUMERIC::TEXT, '+0'::NUMERIC::TEXT
I understand, that convert to text can produce trouble with comparation - Tom Lane give example in this thread, but in this case IEEE 754 doesn't prohibit to show zero without sign. NUMERIC is an example.
Regards
Jarek Stokłosa