From oserra@fondos.net Fri Nov  26 17:33:17 1999
Received: from fondos.net (fondos.net [208.234.1.135])
	by hub.org (8.9.3/8.9.3) with ESMTP id MAA36569
	for <pgsql-interfaces@postgreSQL.org>;
	Fri, 26 Nov 1999 12:33:17 -0500 (EST)
	(envelope-from oserra@fondos.net)
Received: from pep ([195.235.120.7])
	by fondos.net (8.8.8/8.8.5) with SMTP id MAA29863
	for <pgsql-interfaces@postgreSQL.org>; Fri, 26 Nov 1999 12:33:25 -0500
Message-ID: <002e01bf3834$51482280$0778ebc3@pep>
From: "Oscar Serrano" <oserra@fondos.net>
To: <pgsql-interfaces@postgreSQL.org>
Subject: Spanish format on date and numbers
Date: Fri, 26 Nov 1999 18:33:06 +0100
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_002B_01BF383C.AE4DF100"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211

This is a multi-part message in MIME format.

------=_NextPart_000_002B_01BF383C.AE4DF100
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Hi:
I'm from Spain. I've exported some tables from MS Access to Postgres. =
You
know, in Spain, a number like this: 1,234.56 me write it like this:
1.234,56
i.e., the thousand separator is the "." and the decimal separator is the =
","

I'm going to use Perl (DBI) to get the data from the databases.
Is there anyway so DBI or postgress gives me the data in the spanish =
format?

I wouldn't like to use somethink like this:
$result=3D~s/\./,/g;
to convert all "." to "," and vice-versa.

Thank you very much

______________________________

Oscar Serrano



------=_NextPart_000_002B_01BF383C.AE4DF100
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2014.210" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2><BR>Hi:<BR>I'm from Spain. I've =
exported some=20
tables from MS Access to Postgres. You<BR>know, in Spain, a number like =
this:=20
1,234.56 me write it like this:<BR>1.234,56<BR>i.e., the thousand =
separator is=20
the "." and the decimal separator is the ","</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I'm going to use Perl (DBI) to get the =
data from=20
the databases.<BR>Is there anyway so DBI or postgress gives me the data =
in the=20
spanish format?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I wouldn't like to use somethink like=20
this:<BR>$result=3D~s/\./,/g;<BR>to convert all "." to "," and=20
vice-versa.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thank you very much</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial =
size=3D2>______________________________</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Oscar Serrano</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_002B_01BF383C.AE4DF100--




From oserra@fondos.net Fri Nov  26 18:02:15 1999
Received: from fondos.net (fondos.net [208.234.1.135])
	by hub.org (8.9.3/8.9.3) with ESMTP id NAA40740
	for <pgsql-interfaces@postgreSQL.org>;
	Fri, 26 Nov 1999 13:02:15 -0500 (EST)
	(envelope-from oserra@fondos.net)
Received: from pep ([195.235.120.7])
	by fondos.net (8.8.8/8.8.5) with SMTP id NAA31633
	for <pgsql-interfaces@postgreSQL.org>; Fri, 26 Nov 1999 13:02:24 -0500
Message-ID: <005201bf3838$5d9c1f60$0778ebc3@pep>
From: "Oscar Serrano" <oserra@fondos.net>
To: <pgsql-interfaces@postgreSQL.org>
References: <19991126175242.2801.rocketmail@web305.mail.yahoo.com>
Subject: RE: [INTERFACES] Spanish format on date and numbers
Date: Fri, 26 Nov 1999 19:02:09 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211


----- Original Message -----
From: Alain TESIO <alain_tesio@yahoo.com>
To: Oscar Serrano <oserra@fondos.net>
Sent: Friday, November 26, 1999 6:52 PM
Subject: Re: [INTERFACES] Spanish format on date and numbers


> --- Oscar Serrano <oserra@fondos.net> wrote:
>
> > I wouldn't like to use somethink like this:
> > $result=~s/\./,/g;
> > to convert all "." to "," and vice-versa.
>
> The usual trick is to convert "." to "XXX" or whatever
> which doesn't appear in the data themselves, "," to "."
> and "XXX" to ",".
>
> Alain

Yes, yes, I know, but what I was trying to say, is that I would like to get
the result directly in the spanish format, and donīt use any perl code to
convert the format.

Thank you, anyway.



> __________________________________________________
> Do You Yahoo!?
> Thousands of Stores.  Millions of Products.  All in one place.
> Yahoo! Shopping: http://shopping.yahoo.com
>




From prlw1@newn.cam.ac.uk Fri Nov  26 19:00:37 1999
Received: from henry.newn.cam.ac.uk (henry.newn.cam.ac.uk [131.111.204.130])
	by hub.org (8.9.3/8.9.3) with ESMTP id OAA66427
	for <pgsql-interfaces@postgresql.org>;
	Fri, 26 Nov 1999 14:00:37 -0500 (EST)
	(envelope-from prlw1@newn.cam.ac.uk)
Received: from [131.111.204.180] (helo=quartz.newn.cam.ac.uk)
	by henry.newn.cam.ac.uk with esmtp (Exim 2.12 #1)
	id 11rQba-0001Cs-00; Fri, 26 Nov 1999 19:00:26 +0000
Received: from prlw1 by quartz.newn.cam.ac.uk with local (Exim 2.12 #1)
	id 11rQbO-0002Fh-00; Fri, 26 Nov 1999 19:00:14 +0000
Subject: Re: [INTERFACES] Spanish format on date and numbers
To: oserra@fondos.net (Oscar Serrano)
Date: Fri, 26 Nov 1999 19:00:14 +0000 (GMT)
From: "Patrick Welche" <prlw1@newn.cam.ac.uk>
Cc: pgsql-interfaces@postgresql.org
Reply-To: prlw1@cam.ac.uk
In-Reply-To: <002e01bf3834$51482280$0778ebc3@pep> from "Oscar Serrano" at Nov
	26, 99 06:33:06 pm
X-Mailer: ELM [version 2.4 PL25]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Message-Id: <E11rQbO-0002Fh-00@quartz.newn.cam.ac.uk>

Oscar Serrano wrote:
> 
> I'm from Spain. I've exported some tables from MS Access to Postgres.  You
> know, in Spain, a number like this: 1,234.56 me write it like this: 1.234,56
> i.e., the thousand separator is the "." and the decimal separator is the ","

I have never tried, but when building postgresql from source,
configure --enable-locale
might be the answer? (cf. Oleg's page http://www.sai.msu.su/~megera/postgres/)

Cheers,

Patrick



From oserra@fondos.net Fri Nov  26 19:29:28 1999
Received: from fondos.net (fondos.net [208.234.1.135])
	by hub.org (8.9.3/8.9.3) with ESMTP id OAA81630
	for <pgsql-interfaces@postgreSQL.org>;
	Fri, 26 Nov 1999 14:29:28 -0500 (EST)
	(envelope-from oserra@fondos.net)
Received: from pep ([195.235.120.7])
	by fondos.net (8.8.8/8.8.5) with SMTP id OAA02597
	for <pgsql-interfaces@postgreSQL.org>; Fri, 26 Nov 1999 14:29:36 -0500
Message-ID: <006e01bf3844$8c693560$0778ebc3@pep>
From: "Oscar Serrano" <oserra@fondos.net>
To: <pgsql-interfaces@postgreSQL.org>
References: <E11rQbO-0002Fh-00@quartz.newn.cam.ac.uk>
Subject: RE: [INTERFACES] Spanish format on date and numbers
Date: Fri, 26 Nov 1999 20:29:21 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211


----- Original Message -----
From: Patrick Welche <prlw1@newn.cam.ac.uk>
To: Oscar Serrano <oserra@fondos.net>
Cc: <pgsql-interfaces@postgreSQL.org>
Sent: Friday, November 26, 1999 8:00 PM
Subject: Re: [INTERFACES] Spanish format on date and numbers


> Oscar Serrano wrote:
> >
> > I'm from Spain. I've exported some tables from MS Access to Postgres.
You
> > know, in Spain, a number like this: 1,234.56 me write it like this:
1.234,56
> > i.e., the thousand separator is the "." and the decimal separator is the
","
>
> I have never tried, but when building postgresql from source,
> configure --enable-locale
> might be the answer? (cf. Oleg's page
http://www.sai.msu.su/~megera/postgres/)
>
> Cheers,
>

Hi again :-)
Reading some web sites, it seems that, yes, I must use the --enable-locale
at configuration time.
And it seems that I must first define and export the variables LANG, LC_ALL,
LC_CTYPE (and probably LC_COLLATE).
The LANG variable seems to must be: LANG="es_ES", for spanish configuration.
The LC_CTYPE must be something like this: LC_CTYPE="ISO8859-1". But, what is
the ISO for spain?

So, if I define this variables and use the --enable-locale, the psql will
return the numbers and dates in the spanish format?
I can't believe it.

Where are the files that defines how is the spanish format? You know, I'm
installing postgres in a ISP in USA, so very probably, the dedicated server
where I'm installing it, hasn't this files. I think I will need to modify
them, or to upload the spanish definition files.

Thank you very much.


> Patrick
>
> ************
>




From prlw1@newn.cam.ac.uk Sat Nov  27 13:34:04 1999
Received: from henry.newn.cam.ac.uk (henry.newn.cam.ac.uk [131.111.204.130])
	by hub.org (8.9.3/8.9.3) with ESMTP id IAA00968
	for <pgsql-interfaces@postgresql.org>;
	Sat, 27 Nov 1999 08:34:04 -0500 (EST)
	(envelope-from prlw1@newn.cam.ac.uk)
Received: from [131.111.204.180] (helo=quartz.newn.cam.ac.uk)
	by henry.newn.cam.ac.uk with esmtp (Exim 2.12 #1)
	id 11rhzO-0001rE-00; Sat, 27 Nov 1999 13:34:10 +0000
Received: from prlw1 by quartz.newn.cam.ac.uk with local (Exim 2.12 #1)
	id 11rhzG-0002Np-00; Sat, 27 Nov 1999 13:34:02 +0000
Subject: Re: [INTERFACES] Spanish format on date and numbers
To: oserra@fondos.net (Oscar Serrano)
Date: Sat, 27 Nov 1999 13:34:02 +0000 (GMT)
From: "Patrick Welche" <prlw1@newn.cam.ac.uk>
Cc: pgsql-interfaces@postgresql.org
Reply-To: prlw1@cam.ac.uk
In-Reply-To: <006e01bf3844$8c693560$0778ebc3@pep> from "Oscar Serrano" at Nov
	26, 99 08:29:21 pm
X-Mailer: ELM [version 2.4 PL25]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Message-Id: <E11rhzG-0002Np-00@quartz.newn.cam.ac.uk>

Oscar Serrano wrote:

> And it seems that I must first define and export the variables LANG, LC_ALL,
> LC_CTYPE (and probably LC_COLLATE).
> The LANG variable seems to must be: LANG="es_ES", for spanish configuration.
> The LC_CTYPE must be something like this: LC_CTYPE="ISO8859-1". But, what is
> the ISO for spain?

Vague memory tells me it's ISO8859-2. I use LC_CTYPE=iso_8859_1, as in my
/usr/share/locale directory (this is under NetBSD) I have

% ls /usr/share/locale
de         es         iso_8859_1 nl         pl         sl
el         fr         ko         no         ru         sv
% ls /usr/share/locale/iso_8859_1
LC_CTYPE

I don't know where I would find nor how to write an appropriate LC_CTYPE
file - never needed to, and never tried --enable-locale - I just set LC_CTYPE
for nice keyboard sequences.

> So, if I define this variables and use the --enable-locale, the psql will
> return the numbers and dates in the spanish format?
> I can't believe it.

There's only one way to find out!

Good luck,

Patrick



From oserra@fondos.net Mon Nov  29 13:12:44 1999
Received: from fondos.net (fondos.net [208.234.1.135])
	by hub.org (8.9.3/8.9.3) with ESMTP id IAA15414
	for <pgsql-interfaces@postgreSQL.org>;
	Mon, 29 Nov 1999 08:12:44 -0500 (EST)
	(envelope-from oserra@fondos.net)
Received: from pep ([213.4.29.112])
	by fondos.net (8.8.8/8.8.5) with SMTP id IAA09078
	for <pgsql-interfaces@postgreSQL.org>; Mon, 29 Nov 1999 08:13:05 -0500
Message-ID: <002801bf3a6b$68d27d40$701d04d5@pep>
From: "Oscar Serrano" <oserra@fondos.net>
To: <pgsql-interfaces@postgreSQL.org>
References: <199911280627.BAA13538@lee.k12.nc.us>
Subject: RE: [INTERFACES] Spanish format on date and numbers
Date: Mon, 29 Nov 1999 14:12:15 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211


----- Original Message -----
From: James Olin Oden <joden@lee.k12.nc.us>
To: Oscar Serrano <oserra@fondos.net>
Sent: Sunday, November 28, 1999 7:27 AM
Subject: Re: [INTERFACES] Spanish format on date and numbers


> >
> > This is a multi-part message in MIME format.
> >
> > ------=_NextPart_000_002B_01BF383C.AE4DF100
> > Content-Type: text/plain;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> >
> > Hi:
> > I'm from Spain. I've exported some tables from MS Access to Postgres. =
> > You
> > know, in Spain, a number like this: 1,234.56 me write it like this:
> > 1.234,56
> > i.e., the thousand separator is the "." and the decimal separator is the
=
> > ","
> >
> > I'm going to use Perl (DBI) to get the data from the databases.
> > Is there anyway so DBI or postgress gives me the data in the spanish =
> > format?
> >
> > I wouldn't like to use somethink like this:
> > $result=3D~s/\./,/g;
> > to convert all "." to "," and vice-versa.
> >
> Certainly you can use the substitution operator to replace the .'s with
,'s
> and the ,'s with .'s.  The main problem is that the first substitution you
> make will cause all one character to become the character you are about
> to convert next.  As in:
>
> 1,234.52
>
> becomes:
>
> 1.234.52
>
> when replacing your comma.  So on the next step you have no nice way of
telling
> which is the real . you wish to replace with ,.  One way around this is to
> replace one of the symbols with a third symbol not found in a number:
>
> $result =~ s/\./\@/g; # Periods to @'s
> $result =~ s/\,/\./g; # commas to periods
> $result =~ s/\@/\,/g; # @'s to commas
>
> On the other hand if you don't use the susbstitution operator and instead
> use tr, the translation operator, you can get away with doing it in
> one fell swoop:
>
> $result =~ tr/.,/,./;
>
> and that should do it (-:

I never used the tr (translation operator), but I see that in this case is
better that the =~s
But What I was trying is that postgres returns the values in the spanish
format, not having to translate ,'s to .'s and viceversa

As I told in previos messages, I thing I must compile Postgres
with --use-locale and have defined some variables. But I'm not sure how to
define that variables, and in case I have them well defined, I don't know if
it is needed extra configuration in my Linux, or have installed any spanish
library or whatever.

Thank you very much.



> ...james
> > Thank you very much
> >
> > ______________________________
> >
> > Oscar Serrano
> >
> >
> >
> > ------=_NextPart_000_002B_01BF383C.AE4DF100
> > Content-Type: text/html;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > <HTML><HEAD>
> > <META content=3D"text/html; charset=3Diso-8859-1" =
> > http-equiv=3DContent-Type>
> > <META content=3D"MSHTML 5.00.2014.210" name=3DGENERATOR>
> > <STYLE></STYLE>
> > </HEAD>
> > <BODY bgColor=3D#ffffff>
> > <DIV><FONT face=3DArial size=3D2><BR>Hi:<BR>I'm from Spain. I've =
> > exported some=20
> > tables from MS Access to Postgres. You<BR>know, in Spain, a number like
=
> > this:=20
> > 1,234.56 me write it like this:<BR>1.234,56<BR>i.e., the thousand =
> > separator is=20
> > the "." and the decimal separator is the ","</FONT></DIV>
> > <DIV>&nbsp;</DIV>
> > <DIV><FONT face=3DArial size=3D2>I'm going to use Perl (DBI) to get the
=
> > data from=20
> > the databases.<BR>Is there anyway so DBI or postgress gives me the data
=
> > in the=20
> > spanish format?</FONT></DIV>
> > <DIV>&nbsp;</DIV>
> > <DIV><FONT face=3DArial size=3D2>I wouldn't like to use somethink
like=20
> > this:<BR>$result=3D~s/\./,/g;<BR>to convert all "." to "," and=20
> > vice-versa.</FONT></DIV>
> > <DIV>&nbsp;</DIV>
> > <DIV><FONT face=3DArial size=3D2>Thank you very much</FONT></DIV>
> > <DIV>&nbsp;</DIV>
> > <DIV><FONT face=3DArial =
> > size=3D2>______________________________</FONT></DIV>
> > <DIV>&nbsp;</DIV>
> > <DIV><FONT face=3DArial size=3D2>Oscar Serrano</FONT></DIV>
> > <DIV>&nbsp;</DIV>
> > <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></BODY></HTML>
> >
> > ------=_NextPart_000_002B_01BF383C.AE4DF100--
> >
> >
> > ************
> >
>




From meskes@postgreSQL.org Tue Nov  30 10:48:14 1999
Received: from mail.ngi.de ([195.243.0.227])
	by hub.org (8.9.3/8.9.3) with ESMTP id FAA42080
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 30 Nov 1999 05:48:14 -0500 (EST)
	(envelope-from michael@fam-meskes.de)
Received: from p3E9C146D.dip0.t-ipconnect.de
	(root@p3E9C146D.dip0.t-ipconnect.de [62.156.20.109])
	by mail.ngi.de (8.9.3/8.9.3) with ESMTP id LAA96548
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 30 Nov 1999 11:40:43 +0100 (CET)
	(envelope-from michael@fam-meskes.de)
Received: (from michael@localhost)
	by tanja.fam-meskes.de (8.9.3/8.9.0/Debian/GNU) id LAA00386
	for pgsql-interfaces@postgreSQL.org; Tue, 30 Nov 1999 11:27:14 +0100
Date: Tue, 30 Nov 1999 11:27:14 +0100
From: Michael Meskes <meskes@postgreSQL.org>
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Spanish format on date and numbers
Message-ID: <19991130112714.A375@fam-meskes.de>
Mail-Followup-To: pgsql-interfaces@postgreSQL.org
References: <199911280627.BAA13538@lee.k12.nc.us>
	<002801bf3a6b$68d27d40$701d04d5@pep>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
User-Agent: Mutt/1.0i
In-Reply-To: <002801bf3a6b$68d27d40$701d04d5@pep>;
	from oserra@fondos.net on Mon, Nov 29, 1999 at 02:12:15PM +0100

On Mon, Nov 29, 1999 at 02:12:15PM +0100, Oscar Serrano wrote:
> As I told in previos messages, I thing I must compile Postgres
> with --use-locale and have defined some variables. But I'm not sure how to
> define that variables, and in case I have them well defined, I don't know if
> it is needed extra configuration in my Linux, or have installed any spanish
> library or whatever.

Does that mean a localized postmaster returns the number with ',' instead of
'.'? Mine certainly doesn't. 

In fact I remove LC_NUMERIC for ECPG to make sure numbers have the '.' as
decimal seperator.

Could anyone tell me what standard says? Is it "14.7" as my postmaster gives
it to me even with LC_ALL=de_DE and --use-locale or is it "14,7" as the
German locale asks for (and I have a bug in my setup). If the later is
correct ECPG has to go back to the drawing board.

Michael

-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De           | Use PostgreSQL!



From oserra@fondos.net Fri Dec  3 14:45:45 1999
Received: from fondos.net (fondos.net [208.234.1.135])
	by hub.org (8.9.3/8.9.3) with ESMTP id JAA36641
	for <pgsql-interfaces@postgreSQL.org>;
	Fri, 3 Dec 1999 09:45:45 -0500 (EST)
	(envelope-from oserra@fondos.net)
Received: from pep ([213.4.82.200])
	by fondos.net (8.8.8/8.8.5) with SMTP id JAA23712
	for <pgsql-interfaces@postgreSQL.org>; Fri, 3 Dec 1999 09:45:37 -0500
Message-ID: <00c501bf3d9c$e1875b00$c85204d5@pep>
From: "Oscar Serrano" <oserra@fondos.net>
To: <pgsql-interfaces@postgreSQL.org>
References: <199911280627.BAA13538@lee.k12.nc.us>
	<002801bf3a6b$68d27d40$701d04d5@pep>
	<19991130112714.A375@fam-meskes.de>
Subject: RE: [INTERFACES] Spanish format on date and numbers
Date: Fri, 3 Dec 1999 15:44:01 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211


----- Original Message -----
From: Michael Meskes <meskes@postgreSQL.org>
To: <pgsql-interfaces@postgreSQL.org>
Sent: Tuesday, November 30, 1999 11:27 AM
Subject: Re: [INTERFACES] Spanish format on date and numbers


> On Mon, Nov 29, 1999 at 02:12:15PM +0100, Oscar Serrano wrote:
> > As I told in previos messages, I thing I must compile Postgres
> > with --use-locale and have defined some variables. But I'm not sure how
to
> > define that variables, and in case I have them well defined, I don't
know if
> > it is needed extra configuration in my Linux, or have installed any
spanish
> > library or whatever.
>
> Does that mean a localized postmaster returns the number with ',' instead
of
> '.'? Mine certainly doesn't.

Well, I'm not sure. That's what I wanted to know. Reading the not very clear
documentation at this point, I understand that a spanish localiced
postmaster returns the the float numbers with ',' instead of  '.'

I've seen that declaring don't-remember-what variable, the dates were
returned in the west-european format (dd/mm/aa).
Won't be a similar variable to the number format?



> In fact I remove LC_NUMERIC for ECPG to make sure numbers have the '.' as
> decimal seperator.

Reading the documentation of the installation process, I didn't see the
LC_NUMERIC variable anywhere. I only saw references to the LC_ALL, LC_CTYPE,
and LANG.


> Could anyone tell me what standard says? Is it "14.7" as my postmaster
gives
> it to me even with LC_ALL=de_DE and --use-locale or is it "14,7" as the
> German locale asks for (and I have a bug in my setup). If the later is
> correct ECPG has to go back to the drawing board.

The standard, I think, is "14.7" and not "14,7" if you don't use-locale.

Can anybody tell us what variables and how must they be defined before
compile with --use-locale to make the postmaster return values in the
spanish format?

Thanks.


> Michael
>
> --
> Michael Meskes                         | Go SF 49ers!
> Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
> Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
> Email: Michael@Fam-Meskes.De           | Use PostgreSQL!
>
> ************
>
>
>
> ************
>




From meskes@postgresql.org Fri Dec  3 16:03:30 1999
Received: from mail.ngi.de ([195.243.0.227])
	by hub.org (8.9.3/8.9.3) with ESMTP id LAA63473
	for <pgsql-interfaces@postgresql.org>;
	Fri, 3 Dec 1999 11:03:30 -0500 (EST)
	(envelope-from michael@fam-meskes.de)
Received: from p3E9D3E2C.dip0.t-ipconnect.de
	(root@p3E9D3E2C.dip0.t-ipconnect.de [62.157.62.44])
	by mail.ngi.de (8.9.3/8.9.3) with ESMTP id QAA05607;
	Fri, 3 Dec 1999 16:55:09 +0100 (CET)
	(envelope-from michael@fam-meskes.de)
Received: (from michael@localhost)
	by tanja.fam-meskes.de (8.9.3/8.9.3/Debian 8.9.3-6) id QAA01045;
	Fri, 3 Dec 1999 16:46:36 +0100
Date: Fri, 3 Dec 1999 16:46:36 +0100
From: Michael Meskes <meskes@postgresql.org>
To: Oscar Serrano <oserra@fondos.net>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] Spanish format on date and numbers
Message-ID: <19991203164636.B1020@fam-meskes.de>
Mail-Followup-To: Oscar Serrano <oserra@fondos.net>,
	pgsql-interfaces@postgresql.org
References: <199911280627.BAA13538@lee.k12.nc.us>
	<002801bf3a6b$68d27d40$701d04d5@pep>
	<19991130112714.A375@fam-meskes.de>
	<00c501bf3d9c$e1875b00$c85204d5@pep>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
User-Agent: Mutt/1.0i
In-Reply-To: <00c501bf3d9c$e1875b00$c85204d5@pep>;
	from oserra@fondos.net on Fri, Dec 03, 1999 at 03:44:01PM +0100

[Oops, apparently my mail did get through. Sorry for resending the question
to the list.]

On Fri, Dec 03, 1999 at 03:44:01PM +0100, Oscar Serrano wrote:
> Well, I'm not sure. That's what I wanted to know. Reading the not very clear
> documentation at this point, I understand that a spanish localiced
> postmaster returns the the float numbers with ',' instead of  '.'

So that would mean the output honors locale setting. But the input does not
at least not always. After all you cannot type a constant 14,7 in C either. 

But how about a string? 

> > In fact I remove LC_NUMERIC for ECPG to make sure numbers have the '.' as
> > decimal seperator.
> 
> Reading the documentation of the installation process, I didn't see the
> LC_NUMERIC variable anywhere. I only saw references to the LC_ALL, LC_CTYPE,
> and LANG.

I don't care about the settings other than the numerical one. So I only
disabled LC_NUMERIC. But if the postmaster honors locale this solution is
not really working. 

> The standard, I think, is "14.7" and not "14,7" if you don't use-locale.

Sure. But what if I do use-locale?

> Can anybody tell us what variables and how must they be defined before
> compile with --use-locale to make the postmaster return values in the
> spanish format?

Hopefully the answer is that postmaster never does or else I have no idea
how to program libecpg. I would need a way to ask postmaster which locale he
runs in.

Michael
-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De           | Use PostgreSQL!



From lockhart@alumni.caltech.edu Fri Dec  3 16:36:16 1999
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 LAA73625
	for <pgsql-interfaces@postgreSQL.org>;
	Fri, 3 Dec 1999 11:36:16 -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 QAA13466;
	Fri, 3 Dec 1999 16:38:19 GMT
Sender: lockhart@hub.org
Message-ID: <3847F1FB.6AB04307@alumni.caltech.edu>
Date: Fri, 03 Dec 1999 16:38:19 +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: Oscar Serrano <oserra@fondos.net>
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>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> I've seen that declaring don't-remember-what variable, the dates were
> returned in the west-european format (dd/mm/aa).
> Won't be a similar variable to the number format?

No, unfortunately they are not related. The date/time routines can't
simply use localization, because:

1) the allowed time range for several date/time types exceeds the
Unix-supported range.

2) localization for input supports only one style at a time in
general.

We've got explicit code to allow several (4) different date/time
styles, which is what gives you the western European format.

By contrast, we use the system-supplied numeric i/o routines, so don't
have full control over formatting options. That may be a good thing,
since I would assume the system does a more efficient job than we
would.

                   - Thomas

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



From meskes@postgreSQL.org Sat Dec  4 12:40:53 1999
Received: from mail.ngi.de ([195.243.0.227])
	by hub.org (8.9.3/8.9.3) with ESMTP id HAA08687
	for <pgsql-interfaces@postgreSQL.org>;
	Sat, 4 Dec 1999 07:40:53 -0500 (EST)
	(envelope-from michael@fam-meskes.de)
Received: from dialup-212.162.0.135.frankfurt1.mik.net
	(root@dialup-212.162.0.135.frankfurt1.mik.net [212.162.0.135])
	by mail.ngi.de (8.9.3/8.9.3) with ESMTP id NAA69520;
	Sat, 4 Dec 1999 13:32:17 +0100 (CET)
	(envelope-from michael@fam-meskes.de)
Received: (from michael@localhost)
	by tanja.fam-meskes.de (8.9.3/8.9.3/Debian 8.9.3-6) id NAA01476;
	Sat, 4 Dec 1999 13:32:37 +0100
Date: Sat, 4 Dec 1999 13:32:37 +0100
From: Michael Meskes <meskes@postgreSQL.org>
To: Thomas Lockhart <lockhart@alumni.caltech.edu>
Cc: Oscar Serrano <oserra@fondos.net>, pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Spanish format on date and numbers
Message-ID: <19991204133237.A1468@fam-meskes.de>
Mail-Followup-To: Thomas Lockhart <lockhart@alumni.caltech.edu>,
	Oscar Serrano <oserra@fondos.net>, pgsql-interfaces@postgreSQL.org
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>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
User-Agent: Mutt/1.0i
In-Reply-To: <3847F1FB.6AB04307@alumni.caltech.edu>;
	from lockhart@alumni.caltech.edu on Fri, Dec 03, 1999 at
	04:38:19PM +0000

On Fri, Dec 03, 1999 at 04:38:19PM +0000, Thomas Lockhart wrote:
> By contrast, we use the system-supplied numeric i/o routines, so don't
> have full control over formatting options. That may be a good thing,
> since I would assume the system does a more efficient job than we
> would.

So postmaster may output a localized number but it cannot parse a statement
that contains a localized number, right? 

If this is correct, I have to honor locales for output but not for input. 

Michael
-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De           | Use PostgreSQL!



From lockhart@alumni.caltech.edu Mon Dec  6 01:59:19 1999
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 UAA13366;
	Sun, 5 Dec 1999 20:59:19 -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 CAA17526;
	Mon, 6 Dec 1999 02:02:15 GMT
Sender: lockhart@hub.org
Message-ID: <384B1927.A8A0C55E@alumni.caltech.edu>
Date: Mon, 06 Dec 1999 02:02:15 +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: Oscar Serrano <oserra@fondos.net>, 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>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> > By contrast, we use the system-supplied numeric i/o routines, so don't
> > have full control over formatting options. That may be a good thing,
> > since I would assume the system does a more efficient job than we
> > would.
> So postmaster may output a localized number but it cannot parse a statement
> that contains a localized number, right?

I haven't tested this, but we do use the system libraries for reading
numbers. So if they are locale-enabled, then locale-specific numbers
should be recognized...

                     - Thomas

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



From meskes@postgreSQL.org Mon Dec  6 07:58:02 1999
Received: from mail.ngi.de ([195.243.0.227])
	by hub.org (8.9.3/8.9.3) with ESMTP id CAA73194
	for <pgsql-interfaces@postgreSQL.org>;
	Mon, 6 Dec 1999 02:58:02 -0500 (EST)
	(envelope-from michael@fam-meskes.de)
Received: from p3E9D3DE9.dip0.t-ipconnect.de
	(root@p3E9D3DE9.dip0.t-ipconnect.de [62.157.61.233])
	by mail.ngi.de (8.9.3/8.9.3) with ESMTP id IAA21517
	for <pgsql-interfaces@postgreSQL.org>;
	Mon, 6 Dec 1999 08:49:22 +0100 (CET)
	(envelope-from michael@fam-meskes.de)
Received: (from michael@localhost)
	by tanja.fam-meskes.de (8.9.3/8.9.3/Debian 8.9.3-6) id HAA01433
	for pgsql-interfaces@postgreSQL.org; Mon, 6 Dec 1999 07:54:43 +0100
Date: Mon, 6 Dec 1999 07:54:42 +0100
From: Michael Meskes <meskes@postgreSQL.org>
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Spanish format on date and numbers
Message-ID: <19991206075442.A1392@fam-meskes.de>
Mail-Followup-To: pgsql-interfaces@postgreSQL.org
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>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
User-Agent: Mutt/1.0i
In-Reply-To: <384B1927.A8A0C55E@alumni.caltech.edu>;
	from lockhart@alumni.caltech.edu on Mon, Dec 06, 1999 at
	02:02:15AM +0000

On Mon, Dec 06, 1999 at 02:02:15AM +0000, Thomas Lockhart wrote:
> I haven't tested this, but we do use the system libraries for reading
> numbers. So if they are locale-enabled, then locale-specific numbers
> should be recognized...

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

Michael
-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De           | Use PostgreSQL!



From zakkr@zf.jcu.cz Mon Dec  6 08:39:08 1999
Received: from ara.zf.jcu.cz (zakkr@ara.zf.jcu.cz [160.217.161.4])
	by hub.org (8.9.3/8.9.3) with ESMTP id DAA81305;
	Mon, 6 Dec 1999 03:39:08 -0500 (EST) (envelope-from zakkr@zf.jcu.cz)
Received: from localhost (zakkr@localhost)
	by ara.zf.jcu.cz (8.9.3/8.9.3/Debian/GNU) with SMTP id JAA11035;
	Mon, 6 Dec 1999 09:26:07 +0100
Date: Mon, 6 Dec 1999 09:26:07 +0100 (CET)
From: Karel Zak - Zakkr <zakkr@zf.jcu.cz>
To: Michael Meskes <meskes@postgreSQL.org>
cc: Thomas Lockhart <lockhart@alumni.caltech.edu>,
	Oscar Serrano <oserra@fondos.net>, pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Spanish format on date and numbers
In-Reply-To: <19991204133237.A1468@fam-meskes.de>
Message-ID: <Pine.LNX.3.96.991206085928.9928A-100000@ara.zf.jcu.cz>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII


On Sat, 4 Dec 1999, Michael Meskes wrote:

> On Fri, Dec 03, 1999 at 04:38:19PM +0000, Thomas Lockhart wrote:
> > By contrast, we use the system-supplied numeric i/o routines, so don't
> > have full control over formatting options. That may be a good thing,
> > since I would assume the system does a more efficient job than we
> > would.
> 
> So postmaster may output a localized number but it cannot parse a statement
> that contains a localized number, right? 
> 
> If this is correct, I have to honor locales for output but not for input. 
> 

I would like write "number" version of the to_char/from_char. It probably
allow convert string with non-PostgreSQL's numbers (with arbitrary
separators etc.) to standard numbers. But I have it in the head now only:-)  
(it will available in 7.0).

							Karel											

----------------------------------------------------------------------
Karel Zak <zakkr@zf.jcu.cz>              http://home.zf.jcu.cz/~zakkr/

Docs:        http://docs.linux.cz                    (big docs archive)	
Kim Project: http://home.zf.jcu.cz/~zakkr/kim/        (process manager)
FTP:         ftp://ftp2.zf.jcu.cz/users/zakkr/        (C/ncurses/PgSQL)
-----------------------------------------------------------------------




From tgl@sss.pgh.pa.us Mon Dec  6 15:23:03 1999
Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id KAA39352;
	Mon, 6 Dec 1999 10:23:03 -0500 (EST)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id KAA18451;
	Mon, 6 Dec 1999 10:22:32 -0500 (EST)
To: Michael Meskes <meskes@postgreSQL.org>
cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Spanish format on date and numbers 
In-reply-to: Your message of Mon, 6 Dec 1999 07:54:42 +0100
	<19991206075442.A1392@fam-meskes.de>
Date: Mon, 06 Dec 1999 10:22:32 -0500
Message-ID: <18449.944493752@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Michael Meskes <meskes@postgreSQL.org> writes:
> On Mon, Dec 06, 1999 at 02:02:15AM +0000, Thomas Lockhart wrote:
>> I haven't tested this, but we do use the system libraries for reading
>> numbers. So if they are locale-enabled, then locale-specific numbers
>> should be recognized...

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

We can't mess around with SQL syntax --- or would you like

	SELECT 12,34;

to have locale-dependent results?

However, I think we could make the type-specific I/O routines for
appropriate types be locale-dependent.  So you could do

	SELECT '12,34'::int4;

and get the desired behavior in a locale where , is the radix point.

OTOH, arrays of int might be tricky...

			regards, tom lane



From lockhart@alumni.caltech.edu Mon Dec  6 15:38:57 1999
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



From meskes@postgreSQL.org Tue Dec  7 10:30:27 1999
Received: from mail.ngi.de ([195.243.0.227])
	by hub.org (8.9.3/8.9.3) with ESMTP id FAA06900
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 7 Dec 1999 05:30:27 -0500 (EST)
	(envelope-from michael@fam-meskes.de)
Received: from p3E9C144F.dip0.t-ipconnect.de
	(root@p3E9C144F.dip0.t-ipconnect.de [62.156.20.79])
	by mail.ngi.de (8.9.3/8.9.3) with ESMTP id LAA32447
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 7 Dec 1999 11:20:58 +0100 (CET)
	(envelope-from michael@fam-meskes.de)
Received: (from michael@localhost)
	by tanja.fam-meskes.de (8.9.3/8.9.0/Debian/GNU) id LAA01727
	for pgsql-interfaces@postgreSQL.org; Tue, 7 Dec 1999 11:26:39 +0100
Date: Tue, 7 Dec 1999 11:26:38 +0100
From: Michael Meskes <meskes@postgreSQL.org>
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Spanish format on date and numbers
Message-ID: <19991207112638.A1713@fam-meskes.de>
Mail-Followup-To: pgsql-interfaces@postgreSQL.org
References: <19991204133237.A1468@fam-meskes.de>
	<Pine.LNX.3.96.991206085928.9928A-100000@ara.zf.jcu.cz>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
User-Agent: Mutt/1.0i
In-Reply-To: <Pine.LNX.3.96.991206085928.9928A-100000@ara.zf.jcu.cz>;
	from zakkr@zf.jcu.cz on Mon, Dec 06, 1999 at 09:26:07AM +0100

On Mon, Dec 06, 1999 at 09:26:07AM +0100, Karel Zak - Zakkr wrote:
> I would like write "number" version of the to_char/from_char. It probably
> allow convert string with non-PostgreSQL's numbers (with arbitrary
> separators etc.) to standard numbers. But I have it in the head now only:-)  
> (it will available in 7.0).

Sorry, but I don't like that. SQL does ask numbers to use '.' as decimal
point and not ','.

Michael
-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De           | Use PostgreSQL!



From meskes@postgreSQL.org Tue Dec  7 10:30:56 1999
Received: from mail.ngi.de ([195.243.0.227])
	by hub.org (8.9.3/8.9.3) with ESMTP id FAA06946
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 7 Dec 1999 05:30:56 -0500 (EST)
	(envelope-from michael@fam-meskes.de)
Received: from p3E9C144F.dip0.t-ipconnect.de
	(root@p3E9C144F.dip0.t-ipconnect.de [62.156.20.79])
	by mail.ngi.de (8.9.3/8.9.3) with ESMTP id LAA32535
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 7 Dec 1999 11:21:50 +0100 (CET)
	(envelope-from michael@fam-meskes.de)
Received: (from michael@localhost)
	by tanja.fam-meskes.de (8.9.3/8.9.0/Debian/GNU) id LAA01730
	for pgsql-interfaces@postgreSQL.org; Tue, 7 Dec 1999 11:27:27 +0100
Date: Tue, 7 Dec 1999 11:27:27 +0100
From: Michael Meskes <meskes@postgreSQL.org>
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Spanish format on date and numbers
Message-ID: <19991207112727.B1713@fam-meskes.de>
Mail-Followup-To: pgsql-interfaces@postgreSQL.org
References: <19991206075442.A1392@fam-meskes.de>
	<18449.944493752@sss.pgh.pa.us>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
User-Agent: Mutt/1.0i
In-Reply-To: <18449.944493752@sss.pgh.pa.us>;
	from tgl@sss.pgh.pa.us on Mon, Dec 06, 1999 at 10:22:32AM -0500

On Mon, Dec 06, 1999 at 10:22:32AM -0500, Tom Lane wrote:
> We can't mess around with SQL syntax --- or would you like
> 
> 	SELECT 12,34;
> 
> to have locale-dependent results?

Well that exactly was what I wanted to express. Sorry if I was unclear.

> However, I think we could make the type-specific I/O routines for
> appropriate types be locale-dependent.  So you could do
> 
> 	SELECT '12,34'::int4;
> 
> and get the desired behavior in a locale where , is the radix point.

I'm not sure this is the right thing to do.

Michael
-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De           | Use PostgreSQL!



From meskes@postgreSQL.org Tue Dec  7 10:31:10 1999
Received: from mail.ngi.de ([195.243.0.227])
	by hub.org (8.9.3/8.9.3) with ESMTP id FAA06959
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 7 Dec 1999 05:31:10 -0500 (EST)
	(envelope-from michael@fam-meskes.de)
Received: from p3E9C144F.dip0.t-ipconnect.de
	(root@p3E9C144F.dip0.t-ipconnect.de [62.156.20.79])
	by mail.ngi.de (8.9.3/8.9.3) with ESMTP id LAA32578
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 7 Dec 1999 11:22:07 +0100 (CET)
	(envelope-from michael@fam-meskes.de)
Received: (from michael@localhost)
	by tanja.fam-meskes.de (8.9.3/8.9.0/Debian/GNU) id LAA01733
	for pgsql-interfaces@postgreSQL.org; Tue, 7 Dec 1999 11:28:03 +0100
Date: Tue, 7 Dec 1999 11:28:03 +0100
From: Michael Meskes <meskes@postgreSQL.org>
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Spanish format on date and numbers
Message-ID: <19991207112803.C1713@fam-meskes.de>
Mail-Followup-To: pgsql-interfaces@postgreSQL.org
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>
	<384BD947.F7E94FE2@alumni.caltech.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
User-Agent: Mutt/1.0i
In-Reply-To: <384BD947.F7E94FE2@alumni.caltech.edu>;
	from lockhart@alumni.caltech.edu on Mon, Dec 06, 1999 at
	03:41:59PM +0000

On Mon, Dec 06, 1999 at 03:41:59PM +0000, Thomas Lockhart wrote:
> If we started allowing commas in numeric strings it would conflict
> with usual usage; e.g.
> 
>   select 123,156;

And another reason why we should not add locale to SQL.

Michael
-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De           | Use PostgreSQL!



From zakkr@zf.jcu.cz Tue Dec  7 11:42:26 1999
Received: from ara.zf.jcu.cz (zakkr@ara.zf.jcu.cz [160.217.161.4])
	by hub.org (8.9.3/8.9.3) with ESMTP id GAA15515;
	Tue, 7 Dec 1999 06:42:26 -0500 (EST) (envelope-from zakkr@zf.jcu.cz)
Received: from localhost (zakkr@localhost)
	by ara.zf.jcu.cz (8.9.3/8.9.3/Debian/GNU) with SMTP id MAA04414;
	Tue, 7 Dec 1999 12:29:06 +0100
Date: Tue, 7 Dec 1999 12:29:06 +0100 (CET)
From: Karel Zak - Zakkr <zakkr@zf.jcu.cz>
To: Michael Meskes <meskes@postgreSQL.org>
cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Spanish format on date and numbers
In-Reply-To: <19991207112638.A1713@fam-meskes.de>
Message-ID: <Pine.LNX.3.96.991207120452.2896A-100000@ara.zf.jcu.cz>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII


On Tue, 7 Dec 1999, Michael Meskes wrote:

> On Mon, Dec 06, 1999 at 09:26:07AM +0100, Karel Zak - Zakkr wrote:
> > I would like write "number" version of the to_char/from_char. It probably
> > allow convert string with non-PostgreSQL's numbers (with arbitrary
> > separators etc.) to standard numbers. But I have it in the head now only:-)  
> > (it will available in 7.0).
> 
> Sorry, but I don't like that. SQL does ask numbers to use '.' as decimal
> point and not ','.
> 

Uf, what say I about decimal point ',' in (internal) SQL? Nothing...

To_char() is a standard SQL function (see Oracle) which allow you formatting
*output* (example via traditional form for you native language
(Spanish,Czech..)) or (vice versa) allow you read this formated string and
convert it to the *standard* SQL form.

I not want change decimal point in tables, I want feature which allow me 
convert it to my lang. What is bad on this?

And.. to_char() is not about decimal point only (it is only a one feature). 

						Karel 

      




From meskes@postgreSQL.org Tue Dec  7 11:52:48 1999
Received: from mail.ngi.de ([195.243.0.227])
	by hub.org (8.9.3/8.9.3) with ESMTP id GAA16665
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 7 Dec 1999 06:52:48 -0500 (EST)
	(envelope-from michael@fam-meskes.de)
Received: from p3E9C146A.dip0.t-ipconnect.de
	(root@p3E9C146A.dip0.t-ipconnect.de [62.156.20.106])
	by mail.ngi.de (8.9.3/8.9.3) with ESMTP id MAA38211
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 7 Dec 1999 12:43:56 +0100 (CET)
	(envelope-from michael@fam-meskes.de)
Received: (from michael@localhost)
	by p3E9C146A.dip0.t-ipconnect.de (8.9.3/8.9.3/Debian 8.9.3-6) id
	MAA03152
	for pgsql-interfaces@postgreSQL.org; Tue, 7 Dec 1999 12:54:25 +0100
Date: Tue, 7 Dec 1999 12:54:24 +0100
From: Michael Meskes <meskes@postgreSQL.org>
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Spanish format on date and numbers
Message-ID: <19991207125424.A3078@fam-meskes.de>
Mail-Followup-To: pgsql-interfaces@postgreSQL.org
References: <19991207112638.A1713@fam-meskes.de>
	<Pine.LNX.3.96.991207120452.2896A-100000@ara.zf.jcu.cz>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
User-Agent: Mutt/1.0i
In-Reply-To: <Pine.LNX.3.96.991207120452.2896A-100000@ara.zf.jcu.cz>;
	from zakkr@zf.jcu.cz on Tue, Dec 07, 1999 at 12:29:06PM +0100

On Tue, Dec 07, 1999 at 12:29:06PM +0100, Karel Zak - Zakkr wrote:
> Uf, what say I about decimal point ',' in (internal) SQL? Nothing...

Oops, sorry. I see I misunderstood you.

> To_char() is a standard SQL function (see Oracle) which allow you formatting
> *output* (example via traditional form for you native language
> (Spanish,Czech..)) or (vice versa) allow you read this formated string and
> convert it to the *standard* SQL form.

Sure.

> I not want change decimal point in tables, I want feature which allow me 
> convert it to my lang. What is bad on this?
> 
> And.. to_char() is not about decimal point only (it is only a one feature). 

Nothing wrong with this. Just my understanding of your mail was wrong.
Shouldn't reply to mails while in talking to someone on the phone. :-)

Michael
-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De           | Use PostgreSQL!



From zakkr@zf.jcu.cz Tue Dec  7 12:13:29 1999
Received: from ara.zf.jcu.cz (zakkr@ara.zf.jcu.cz [160.217.161.4])
	by hub.org (8.9.3/8.9.3) with ESMTP id HAA19346;
	Tue, 7 Dec 1999 07:13:29 -0500 (EST) (envelope-from zakkr@zf.jcu.cz)
Received: from localhost (zakkr@localhost)
	by ara.zf.jcu.cz (8.9.3/8.9.3/Debian/GNU) with SMTP id NAA05933;
	Tue, 7 Dec 1999 13:00:10 +0100
Date: Tue, 7 Dec 1999 13:00:10 +0100 (CET)
From: Karel Zak - Zakkr <zakkr@zf.jcu.cz>
To: Michael Meskes <meskes@postgreSQL.org>
cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Spanish format on date and numbers
In-Reply-To: <19991207125424.A3078@fam-meskes.de>
Message-ID: <Pine.LNX.3.96.991207125612.2896D-100000@ara.zf.jcu.cz>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII


All is right.

> Nothing wrong with this. Just my understanding of your mail was wrong.
> Shouldn't reply to mails while in talking to someone on the phone. :-)

 Hmm, multitasking is not problem  for software only - I still fight
with this... :-) 

						Karel