Re: monetary bug - Mailing list pgsql-hackers

From Karel Zak
Subject Re: monetary bug
Date
Msg-id 20040823140728.GC17568@zf.jcu.cz
Whole thread Raw
In response to Re: monetary bug  (Dennis Bjorklund <db@zigo.dhs.org>)
List pgsql-hackers
On Mon, Aug 23, 2004 at 02:52:44PM +0200, Dennis Bjorklund wrote:
> On Mon, 23 Aug 2004, Karel Zak wrote:
> 
> >  I  think it's  pretty extendable  solution in  contrast to  the current
> >  hardcoded  in/out  datetypes  functions.
> 
> Who are we formatting for? If the client wants the data in a specific
> format then they can do SELECT to_char(...), or do the formatting in the
> client all together.
Yes. But some people call for datetypes with integrated formatting (forexample  "money"). I  think  we  should support
_common_ way  how  doformatting  (not only  for "money")  _OR_ we  should reject  types like"money" and do formatting
onlyby extra functions like to_char().
 

> The database should manage data, presenting it to the user in different 
> ways are the job of a client.
Sure, do you want to read data in binary format that PostgreSQL uses indb files  or do you expect  it in some nice
string?PostgreSQL alreadydoes  data  formating almost  for  all  datetypes  -- see  sources  anddatetypes in/out
functions.
   Karel   
-- Karel Zak  <zakkr@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE