Received: from localhost (IDENT:root@hectic-2.jpl.nasa.gov [128.149.68.204])
	by hub.org (8.9.3/8.9.3) with ESMTP id KAA42539;
	Mon, 6 Dec 1999 10:38:57 -0500 (EST)
	(envelope-from lockhart@alumni.caltech.edu)
Received: from alumni.caltech.edu (lockhart@localhost [127.0.0.1])
	by localhost (8.8.7/8.8.7) with ESMTP id PAA18761;
	Mon, 6 Dec 1999 15:41:59 GMT
Sender: lockhart@hub.org
Message-ID: <384BD947.F7E94FE2@alumni.caltech.edu>
Date: Mon, 06 Dec 1999 15:41:59 +0000
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.0.36 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Michael Meskes <meskes@postgreSQL.org>
CC: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Spanish format on date and numbers
References: <199911280627.BAA13538@lee.k12.nc.us>
	<002801bf3a6b$68d27d40$701d04d5@pep>
	<19991130112714.A375@fam-meskes.de>
	<00c501bf3d9c$e1875b00$c85204d5@pep>
	<3847F1FB.6AB04307@alumni.caltech.edu>
	<19991204133237.A1468@fam-meskes.de>
	<384B1927.A8A0C55E@alumni.caltech.edu>
	<19991206075442.A1392@fam-meskes.de>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> Yes, but the parser probably won't. It definitely only lists a decimal
> point.

Ah, right! And I'm not sure how to tell it to understand the current
value of the environment variables and to change its behavior.

If we started allowing commas in numeric strings it would conflict
with usual usage; e.g.

  select 123,156;

should give you two columns, but might be interpreted instead as a six
digit integer. Note that if you surround any number with single quotes
you will get past the parser unscathed:

  select int '123,456';

gets you to the system i/o routines which are locale-enabled.

                    - Thomas

-- 
Thomas Lockhart				lockhart@alumni.caltech.edu
South Pasadena, California