pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Spanish format on date and numbers
22+ messages / 7 participants
[nested] [flat]

* Spanish format on date and numbers
@ 1999-11-26 17:33 Oscar Serrano <oserra@fondos.net>
  1999-11-26 19:00 ` Re: [INTERFACES] Spanish format on date and numbers Patrick Welche <prlw1@newn.cam.ac.uk>
  0 siblings, 1 reply; 22+ messages in thread

From: Oscar Serrano @ 1999-11-26 17:33 UTC (permalink / raw)
  To: pgsql-interfaces


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=~s/\./,/g;
to convert all "." to "," and vice-versa.

Thank you very much

______________________________

Oscar Serrano

^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: [INTERFACES] Spanish format on date and numbers
  1999-11-26 17:33 Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
@ 1999-11-26 19:00 ` Patrick Welche <prlw1@newn.cam.ac.uk>
  1999-11-26 19:29   ` RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  0 siblings, 1 reply; 22+ messages in thread

From: Patrick Welche @ 1999-11-26 19:00 UTC (permalink / raw)
  To: oserra@fondos.net; +Cc: pgsql-interfaces

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



^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* RE: [INTERFACES] Spanish format on date and numbers
  1999-11-26 17:33 Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-11-26 19:00 ` Re: [INTERFACES] Spanish format on date and numbers Patrick Welche <prlw1@newn.cam.ac.uk>
@ 1999-11-26 19:29   ` Oscar Serrano <oserra@fondos.net>
  1999-11-27 13:34     ` Re: [INTERFACES] Spanish format on date and numbers Patrick Welche <prlw1@newn.cam.ac.uk>
  0 siblings, 1 reply; 22+ messages in thread

From: Oscar Serrano @ 1999-11-26 19:29 UTC (permalink / raw)
  To: pgsql-interfaces


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




^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: [INTERFACES] Spanish format on date and numbers
  1999-11-26 17:33 Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-11-26 19:00 ` Re: [INTERFACES] Spanish format on date and numbers Patrick Welche <prlw1@newn.cam.ac.uk>
  1999-11-26 19:29   ` RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
@ 1999-11-27 13:34     ` Patrick Welche <prlw1@newn.cam.ac.uk>
  0 siblings, 0 replies; 22+ messages in thread

From: Patrick Welche @ 1999-11-27 13:34 UTC (permalink / raw)
  To: oserra@fondos.net; +Cc: pgsql-interfaces

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



^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* RE: [INTERFACES] Spanish format on date and numbers
@ 1999-11-26 18:02 Oscar Serrano <oserra@fondos.net>
  0 siblings, 0 replies; 22+ messages in thread

From: Oscar Serrano @ 1999-11-26 18:02 UTC (permalink / raw)
  To: pgsql-interfaces


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




^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* RE: [INTERFACES] Spanish format on date and numbers
@ 1999-11-29 13:12 Oscar Serrano <oserra@fondos.net>
  1999-11-30 10:27 ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  0 siblings, 1 reply; 22+ messages in thread

From: Oscar Serrano @ 1999-11-29 13:12 UTC (permalink / raw)
  To: pgsql-interfaces


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




^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: [INTERFACES] Spanish format on date and numbers
  1999-11-29 13:12 RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
@ 1999-11-30 10:27 ` Michael Meskes <meskes@postgreSQL.org>
  1999-12-03 14:44   ` RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  0 siblings, 1 reply; 22+ messages in thread

From: Michael Meskes @ 1999-11-30 10:27 UTC (permalink / raw)
  To: pgsql-interfaces

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!



^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* RE: [INTERFACES] Spanish format on date and numbers
  1999-11-29 13:12 RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-11-30 10:27 ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
@ 1999-12-03 14:44   ` Oscar Serrano <oserra@fondos.net>
  1999-12-03 15:46     ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgresql.org>
  1999-12-03 16:38     ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
  0 siblings, 2 replies; 22+ messages in thread

From: Oscar Serrano @ 1999-12-03 14:44 UTC (permalink / raw)
  To: pgsql-interfaces


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




^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: [INTERFACES] Spanish format on date and numbers
  1999-11-29 13:12 RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-11-30 10:27 ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-03 14:44   ` RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
@ 1999-12-03 15:46     ` Michael Meskes <meskes@postgresql.org>
  1 sibling, 0 replies; 22+ messages in thread

From: Michael Meskes @ 1999-12-03 15:46 UTC (permalink / raw)
  To: Oscar Serrano <oserra@fondos.net>; +Cc: pgsql-interfaces

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



^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: [INTERFACES] Spanish format on date and numbers
  1999-11-29 13:12 RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-11-30 10:27 ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-03 14:44   ` RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
@ 1999-12-03 16:38     ` Thomas Lockhart <lockhart@alumni.caltech.edu>
  1999-12-04 12:32       ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1 sibling, 1 reply; 22+ messages in thread

From: Thomas Lockhart @ 1999-12-03 16:38 UTC (permalink / raw)
  To: Oscar Serrano <oserra@fondos.net>; +Cc: pgsql-interfaces

> 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



^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: [INTERFACES] Spanish format on date and numbers
  1999-11-29 13:12 RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-11-30 10:27 ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-03 14:44   ` RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-12-03 16:38     ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
@ 1999-12-04 12:32       ` Michael Meskes <meskes@postgreSQL.org>
  1999-12-06 02:02         ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
  1999-12-06 08:26         ` Re: [INTERFACES] Spanish format on date and numbers Karel Zak - Zakkr <zakkr@zf.jcu.cz>
  0 siblings, 2 replies; 22+ messages in thread

From: Michael Meskes @ 1999-12-04 12:32 UTC (permalink / raw)
  To: Thomas Lockhart <lockhart@alumni.caltech.edu>; +Cc: Oscar Serrano <oserra@fondos.net>; pgsql-interfaces

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!



^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: [INTERFACES] Spanish format on date and numbers
  1999-11-29 13:12 RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-11-30 10:27 ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-03 14:44   ` RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-12-03 16:38     ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
  1999-12-04 12:32       ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
@ 1999-12-06 02:02         ` Thomas Lockhart <lockhart@alumni.caltech.edu>
  1999-12-06 06:54           ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1 sibling, 1 reply; 22+ messages in thread

From: Thomas Lockhart @ 1999-12-06 02:02 UTC (permalink / raw)
  To: Michael Meskes <meskes@postgreSQL.org>; +Cc: Oscar Serrano <oserra@fondos.net>; pgsql-interfaces

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



^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: [INTERFACES] Spanish format on date and numbers
  1999-11-29 13:12 RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-11-30 10:27 ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-03 14:44   ` RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-12-03 16:38     ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
  1999-12-04 12:32       ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-06 02:02         ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
@ 1999-12-06 06:54           ` Michael Meskes <meskes@postgreSQL.org>
  1999-12-06 15:22             ` Re: [INTERFACES] Spanish format on date and numbers Tom Lane <tgl@sss.pgh.pa.us>
  1999-12-06 15:41             ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
  0 siblings, 2 replies; 22+ messages in thread

From: Michael Meskes @ 1999-12-06 06:54 UTC (permalink / raw)
  To: pgsql-interfaces

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!



^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: [INTERFACES] Spanish format on date and numbers
  1999-11-29 13:12 RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-11-30 10:27 ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-03 14:44   ` RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-12-03 16:38     ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
  1999-12-04 12:32       ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-06 02:02         ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
  1999-12-06 06:54           ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
@ 1999-12-06 15:22             ` Tom Lane <tgl@sss.pgh.pa.us>
  1999-12-07 10:27               ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1 sibling, 1 reply; 22+ messages in thread

From: Tom Lane @ 1999-12-06 15:22 UTC (permalink / raw)
  To: Michael Meskes <meskes@postgreSQL.org>; +Cc: pgsql-interfaces

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



^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: [INTERFACES] Spanish format on date and numbers
  1999-11-29 13:12 RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-11-30 10:27 ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-03 14:44   ` RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-12-03 16:38     ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
  1999-12-04 12:32       ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-06 02:02         ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
  1999-12-06 06:54           ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-06 15:22             ` Re: [INTERFACES] Spanish format on date and numbers Tom Lane <tgl@sss.pgh.pa.us>
@ 1999-12-07 10:27               ` Michael Meskes <meskes@postgreSQL.org>
  0 siblings, 0 replies; 22+ messages in thread

From: Michael Meskes @ 1999-12-07 10:27 UTC (permalink / raw)
  To: pgsql-interfaces

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!



^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: [INTERFACES] Spanish format on date and numbers
  1999-11-29 13:12 RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-11-30 10:27 ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-03 14:44   ` RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-12-03 16:38     ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
  1999-12-04 12:32       ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-06 02:02         ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
  1999-12-06 06:54           ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
@ 1999-12-06 15:41             ` Thomas Lockhart <lockhart@alumni.caltech.edu>
  1999-12-07 10:28               ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1 sibling, 1 reply; 22+ messages in thread

From: Thomas Lockhart @ 1999-12-06 15:41 UTC (permalink / raw)
  To: Michael Meskes <meskes@postgreSQL.org>; +Cc: pgsql-interfaces

> 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



^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: [INTERFACES] Spanish format on date and numbers
  1999-11-29 13:12 RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-11-30 10:27 ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-03 14:44   ` RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-12-03 16:38     ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
  1999-12-04 12:32       ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-06 02:02         ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
  1999-12-06 06:54           ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-06 15:41             ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
@ 1999-12-07 10:28               ` Michael Meskes <meskes@postgreSQL.org>
  0 siblings, 0 replies; 22+ messages in thread

From: Michael Meskes @ 1999-12-07 10:28 UTC (permalink / raw)
  To: pgsql-interfaces

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!



^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: [INTERFACES] Spanish format on date and numbers
  1999-11-29 13:12 RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-11-30 10:27 ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-03 14:44   ` RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-12-03 16:38     ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
  1999-12-04 12:32       ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
@ 1999-12-06 08:26         ` Karel Zak - Zakkr <zakkr@zf.jcu.cz>
  1999-12-07 10:26           ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1 sibling, 1 reply; 22+ messages in thread

From: Karel Zak - Zakkr @ 1999-12-06 08:26 UTC (permalink / raw)
  To: Michael Meskes <meskes@postgreSQL.org>; +Cc: Thomas Lockhart <lockhart@alumni.caltech.edu>; Oscar Serrano <oserra@fondos.net>; pgsql-interfaces


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




^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: [INTERFACES] Spanish format on date and numbers
  1999-11-29 13:12 RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-11-30 10:27 ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-03 14:44   ` RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-12-03 16:38     ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
  1999-12-04 12:32       ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-06 08:26         ` Re: [INTERFACES] Spanish format on date and numbers Karel Zak - Zakkr <zakkr@zf.jcu.cz>
@ 1999-12-07 10:26           ` Michael Meskes <meskes@postgreSQL.org>
  1999-12-07 11:29             ` Re: [INTERFACES] Spanish format on date and numbers Karel Zak - Zakkr <zakkr@zf.jcu.cz>
  0 siblings, 1 reply; 22+ messages in thread

From: Michael Meskes @ 1999-12-07 10:26 UTC (permalink / raw)
  To: pgsql-interfaces

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!



^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: [INTERFACES] Spanish format on date and numbers
  1999-11-29 13:12 RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-11-30 10:27 ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-03 14:44   ` RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-12-03 16:38     ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
  1999-12-04 12:32       ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-06 08:26         ` Re: [INTERFACES] Spanish format on date and numbers Karel Zak - Zakkr <zakkr@zf.jcu.cz>
  1999-12-07 10:26           ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
@ 1999-12-07 11:29             ` Karel Zak - Zakkr <zakkr@zf.jcu.cz>
  1999-12-07 11:54               ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  0 siblings, 1 reply; 22+ messages in thread

From: Karel Zak - Zakkr @ 1999-12-07 11:29 UTC (permalink / raw)
  To: Michael Meskes <meskes@postgreSQL.org>; +Cc: pgsql-interfaces


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 

      




^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: [INTERFACES] Spanish format on date and numbers
  1999-11-29 13:12 RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-11-30 10:27 ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-03 14:44   ` RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-12-03 16:38     ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
  1999-12-04 12:32       ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-06 08:26         ` Re: [INTERFACES] Spanish format on date and numbers Karel Zak - Zakkr <zakkr@zf.jcu.cz>
  1999-12-07 10:26           ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-07 11:29             ` Re: [INTERFACES] Spanish format on date and numbers Karel Zak - Zakkr <zakkr@zf.jcu.cz>
@ 1999-12-07 11:54               ` Michael Meskes <meskes@postgreSQL.org>
  1999-12-07 12:00                 ` Re: [INTERFACES] Spanish format on date and numbers Karel Zak - Zakkr <zakkr@zf.jcu.cz>
  0 siblings, 1 reply; 22+ messages in thread

From: Michael Meskes @ 1999-12-07 11:54 UTC (permalink / raw)
  To: pgsql-interfaces

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!



^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: [INTERFACES] Spanish format on date and numbers
  1999-11-29 13:12 RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-11-30 10:27 ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-03 14:44   ` RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
  1999-12-03 16:38     ` Re: [INTERFACES] Spanish format on date and numbers Thomas Lockhart <lockhart@alumni.caltech.edu>
  1999-12-04 12:32       ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-06 08:26         ` Re: [INTERFACES] Spanish format on date and numbers Karel Zak - Zakkr <zakkr@zf.jcu.cz>
  1999-12-07 10:26           ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
  1999-12-07 11:29             ` Re: [INTERFACES] Spanish format on date and numbers Karel Zak - Zakkr <zakkr@zf.jcu.cz>
  1999-12-07 11:54               ` Re: [INTERFACES] Spanish format on date and numbers Michael Meskes <meskes@postgreSQL.org>
@ 1999-12-07 12:00                 ` Karel Zak - Zakkr <zakkr@zf.jcu.cz>
  0 siblings, 0 replies; 22+ messages in thread

From: Karel Zak - Zakkr @ 1999-12-07 12:00 UTC (permalink / raw)
  To: Michael Meskes <meskes@postgreSQL.org>; +Cc: pgsql-interfaces


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




^ permalink  raw  reply  [nested|flat] 22+ messages in thread


end of thread, other threads:[~1999-12-07 12:00 UTC | newest]

Thread overview: 22+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-11-26 17:33 Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
1999-11-26 19:00 ` Patrick Welche <prlw1@newn.cam.ac.uk>
1999-11-26 19:29   ` Oscar Serrano <oserra@fondos.net>
1999-11-27 13:34     ` Patrick Welche <prlw1@newn.cam.ac.uk>
1999-11-26 18:02 RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
1999-11-29 13:12 RE: [INTERFACES] Spanish format on date and numbers Oscar Serrano <oserra@fondos.net>
1999-11-30 10:27 ` Michael Meskes <meskes@postgreSQL.org>
1999-12-03 14:44   ` Oscar Serrano <oserra@fondos.net>
1999-12-03 15:46     ` Michael Meskes <meskes@postgresql.org>
1999-12-03 16:38     ` Thomas Lockhart <lockhart@alumni.caltech.edu>
1999-12-04 12:32       ` Michael Meskes <meskes@postgreSQL.org>
1999-12-06 02:02         ` Thomas Lockhart <lockhart@alumni.caltech.edu>
1999-12-06 06:54           ` Michael Meskes <meskes@postgreSQL.org>
1999-12-06 15:22             ` Tom Lane <tgl@sss.pgh.pa.us>
1999-12-07 10:27               ` Michael Meskes <meskes@postgreSQL.org>
1999-12-06 15:41             ` Thomas Lockhart <lockhart@alumni.caltech.edu>
1999-12-07 10:28               ` Michael Meskes <meskes@postgreSQL.org>
1999-12-06 08:26         ` Karel Zak - Zakkr <zakkr@zf.jcu.cz>
1999-12-07 10:26           ` Michael Meskes <meskes@postgreSQL.org>
1999-12-07 11:29             ` Karel Zak - Zakkr <zakkr@zf.jcu.cz>
1999-12-07 11:54               ` Michael Meskes <meskes@postgreSQL.org>
1999-12-07 12:00                 ` Karel Zak - Zakkr <zakkr@zf.jcu.cz>

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