Too much money...: more i18n blues

From: Allan Engelhardt <allane(at)cybaea(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Too much money...: more i18n blues
Date: 2001-07-03 19:26:33
Message-ID: 3B421C69.58AD21D6@cybaea.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

The regression test for int8 fails on my system because it does not expect the currency symbol in

test=> select to_char(123, 'L999');
to_char
---------
$ 123
(1 row)

I'm not sure what the problem is. The server is started with LANG="en_US" and all other locale parameters unset (AFAICT). This is the default
from the RPM startup script, so I don't know what the problem is.

1. Should there be a '$' sign in the en_US language (I guess so?)
2. I have tried to unset the LANG variable in the startup script, and I still get the same output. Is this the "right" place to set LANG for the
postmaster application?
3. Is the regression script crazy? ;-)

Help!?

Allan.

expedted/int8.out has (line 236ff)

SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000') FROM INT8_TBL;
to_char_13 | to_char
------------+------------------------
| 456.000
| 4567890123456789.000
| 123.000
| 4567890123456789.000
| -4567890123456789.000
(5 rows)

while results/int8.out has

SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000') FROM INT8_TBL;
to_char_13 | to_char
------------+------------------------
| $ 456.000
| $ 4567890123456789.000
| $ 123.000
| $ 4567890123456789.000
| $-4567890123456789.000
(5 rows)

bash-2.04$ rpm -qi postgresql
Name : postgresql Relocations: (not relocateable)
Version : 7.1.2 Vendor: (none)
Release : 4PGDG Build Date: Wed 13 Jun 2001 10:18:46 PM BST
Install date: Fri 29 Jun 2001 08:43:51 PM BST Build Host: lowen.wgcr.org
Group : Applications/Databases Source RPM: postgresql-7.1.2-4PGDG.src.rpm
Size : 4426307 License: BSD
URL : http://www.postgresql.org/
Summary : PostgreSQL client programs and libraries.

bash-2.04$ uname -a # RedHat 7.1 US version.
Linux XXXX 2.4.2-2 #17 SMP Tue Jul 3 14:48:45 BST 2001 i686 unknown

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2001-07-03 19:48:30 Re: Character collating order
Previous Message Allan Engelhardt 2001-07-03 18:54:30 Character collating order