Re: [INTERFACES] Spanish format on date and numbers

From: Karel Zak - Zakkr <zakkr(at)zf(dot)jcu(dot)cz>
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-07 11:29:06
Message-ID: Pine.LNX.3.96.991207120452.2896A-100000@ara.zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Rolf Staege 1999-12-07 11:49:38 JDBC: Problems to find the Driverclasses
Previous Message Michael Meskes 1999-12-07 10:28:03 Re: [INTERFACES] Spanish format on date and numbers