pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
question about money type
3+ messages / 3 participants
[nested] [flat]

* question about money type
@ 1999-05-12 13:54 Marcio Macedo <marciom@conectiva.com.br>
  1999-05-12 15:13 ` Re: [SQL] question about money type D'Arcy J.M. Cain <darcy@druid.net>
  0 siblings, 1 reply; 3+ messages in thread

From: Marcio Macedo @ 1999-05-12 13:54 UTC (permalink / raw)
  To: pgsql-sql


Hi all,

when I do a SELECT in a money field, it returns the folowing :

R$2.244,00

what is correct , according with my LOCALE settings,
is there a way to format this result to 

2.244,00 (without the "R$") ?


--Marcio Macedo
	Conectiva





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

* Re: [SQL] question about money type
  1999-05-12 13:54 question about money type Marcio Macedo <marciom@conectiva.com.br>
@ 1999-05-12 15:13 ` D'Arcy J.M. Cain <darcy@druid.net>
  1999-05-12 15:39   ` Re: [SQL] question about money type Jan Wieck <jwieck@debis.com>
  0 siblings, 1 reply; 3+ messages in thread

From: "D'Arcy" "J.M." Cain @ 1999-05-12 15:13 UTC (permalink / raw)
  To: marciom@conectiva.com.br; +Cc: pgsql-sql

Thus spake Marcio Macedo
> Hi all,
> 
> when I do a SELECT in a money field, it returns the folowing :
> 
> R$2.244,00
> 
> what is correct , according with my LOCALE settings,
> is there a way to format this result to 
> 
> 2.244,00 (without the "R$") ?

Not really.  There was once some discussion about removing the currency
string altogether on output (I even sent in patches) but it was decided
to keep it in because no one will be using the MONEY type eventually.
Everyone is being urged to use the NUMERIC type.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.



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

* Re: [SQL] question about money type
  1999-05-12 13:54 question about money type Marcio Macedo <marciom@conectiva.com.br>
  1999-05-12 15:13 ` Re: [SQL] question about money type D'Arcy J.M. Cain <darcy@druid.net>
@ 1999-05-12 15:39   ` Jan Wieck <jwieck@debis.com>
  0 siblings, 0 replies; 3+ messages in thread

From: jwieck@debis.com @ 1999-05-12 15:39 UTC (permalink / raw)
  To: pgsql-sql; +Cc: marciom@conectiva.com.br

D'Arcy J.M. Cain wrote:

>
> Thus spake Marcio Macedo
> > Hi all,
> >
> > when I do a SELECT in a money field, it returns the folowing :
> >
> > R$2.244,00
> >
> > what is correct , according with my LOCALE settings,
> > is there a way to format this result to
> >
> > 2.244,00 (without the "R$") ?
>
> Not really.  There was once some discussion about removing the currency
> string altogether on output (I even sent in patches) but it was decided
> to keep it in because no one will be using the MONEY type eventually.
> Everyone is being urged to use the NUMERIC type.

    I  really wanted to add TO_CHAR() function for NUMERIC before
    release. But there are more important items  in  the  rewrite
    system I have to fix first.

    Since  TO_CHAR()  cannot have any side effects I could add it
    until the last hour before Marc starts "closed shop".


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #





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


end of thread, other threads:[~1999-05-12 15:39 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-05-12 13:54 question about money type Marcio Macedo <marciom@conectiva.com.br>
1999-05-12 15:13 ` D'Arcy J.M. Cain <darcy@druid.net>
1999-05-12 15:39   ` Jan Wieck <jwieck@debis.com>

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