Unnexpected results using to_number()

From: "Andrew Snow" <andrew(at)modulus(dot)org>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Unnexpected results using to_number()
Date: 2000-07-09 05:37:13
Message-ID: NHEALMDKDACEIPBNOOOCOEDACHAA.andrew@modulus.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Is this supposed to happen? I discovered this when I was experimenting with
converting a string to a number.

# SELECT to_number('12,454.8-', '99G999D9S');
to_number
-----------
-12454.8
(1 row)

# SELECT to_number('12,454.8-', '');
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!#

I am running PostgreSQL 7.0.2 on FreeBSD 3.4-STABLE (x86). Thanks,

- Andrew.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew McMillan 2000-07-09 10:42:39 Periodic freezing of backend processes
Previous Message Robert B. Easter 2000-07-07 21:43:35 pg_dump of functions containing \' fail to restore (if not corrected by hand)

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Warner 2000-07-09 08:00:33 Interesting featurette?
Previous Message Chris Bitmead 2000-07-09 04:51:21 Re: libpq / SQL3