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.
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) |
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 |