Re: [INTERFACES] Spanish format on date and numbers - Mailing list pgsql-interfaces

From Thomas Lockhart
Subject Re: [INTERFACES] Spanish format on date and numbers
Date
Msg-id 384BD947.F7E94FE2@alumni.caltech.edu
Whole thread Raw
In response to RE: [INTERFACES] Spanish format on date and numbers  ("Oscar Serrano" <oserra@fondos.net>)
Responses Re: [INTERFACES] Spanish format on date and numbers  (Michael Meskes <meskes@postgreSQL.org>)
List 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


pgsql-interfaces by date:

Previous
From: Robert Hiltibidal
Date:
Subject: Appreciation
Next
From: StOo
Date:
Subject: [INTERFACES] field types