crash on cash_words('21,474,836.48'::money)

From: Eugene Pervago <pervago(at)prodigy(dot)net(dot)mx>
To: pgsql-bugs(at)postgresql(dot)org
Subject: crash on cash_words('21,474,836.48'::money)
Date: 2002-02-17 21:45:34
Message-ID: 1013982335.14218.1.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Eugene Pervago
Your email address : eugene(at)ulkatech(dot)com

System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium III

Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.17

PostgreSQL version (example: PostgreSQL-7.1.1): PostgreSQL-7.2

Compiler used (example: gcc 2.95.2) : gcc 2.96 (Mandrake Cooker RPM)

Please enter a FULL description of your problem:
------------------------------------------------
Executing "select cash_words('21,474,836.48'::money);" (number in cents is 2^31)
consistently crashes the server. Using any number above that returns in negative
results (minus ....) because of the wraparound, using any number below is fine.

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
1. select cash_words('21,474,836.48'::money);
2. Crashes.

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2002-02-18 11:35:12 Bug #592: postgresql-odbc-7.2-1PGDG.i386.rpm lacks the actual shared library
Previous Message Tom Lane 2002-02-16 18:47:43 Re: Bug #591: Postgres apparently not identifying users created in Caps