From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: Michael Meskes <meskes@postgreSQL.org>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Spanish format on date and numbers
Date: Mon, 06 Dec 1999 15:41:59 +0000
Message-ID: <384BD947.F7E94FE2@alumni.caltech.edu> (raw)
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>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: lockhart@alumni.caltech.edu, meskes@postgreSQL.org
Subject: Re: [INTERFACES] Spanish format on date and numbers
In-Reply-To: <384BD947.F7E94FE2@alumni.caltech.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox