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