Re: [INTERFACES] Spanish format on date and numbers

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Michael Meskes <meskes(at)postgreSQL(dot)org>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] Spanish format on date and numbers
Date: 1999-12-06 15:41:59
Message-ID: 384BD947.F7E94FE2@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)alumni(dot)caltech(dot)edu
South Pasadena, California

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 1999-12-06 16:07:56 Re: [INTERFACES] Problems with postgres V6.5.3 large objects
Previous Message Robert Hiltibidal 1999-12-06 15:35:37 Appreciation