Received: from proxy.bazzanese.com (sferac@ip176.tol11.interbusiness.it [195.120.106.176]) by hub.org (8.8.8/8.7.5) with ESMTP id JAA11738 for ; Tue, 16 Jun 1998 09:33:24 -0400 (EDT) Received: from localhost (sferac@localhost) by proxy.bazzanese.com (8.8.8/8.8.8/Debian/GNU) with SMTP id PAA09260; Tue, 16 Jun 1998 15:24:48 GMT Date: Tue, 16 Jun 1998 15:24:47 +0000 (UTC) From: "Jose' Soares Da Silva" X-Sender: sferac@proxy To: Marcio Macedo cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] handle the MONEY type In-Reply-To: <358635C9.FB45DF59@conectiva.com.br> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Tue, 16 Jun 1998, Marcio Macedo wrote: > Hi > > How can I handle the type money ? (if is exists), how can I make > insertions and settings ??? > prova=> create table prova (dinheiro money); CREATE prova=> insert into prova values (12.50); INSERT 202089 1 prova=> insert into prova values (10); INSERT 202090 1 prova=> select * from prova; dinheiro -------- $12.50 $10.00 (2 rows) prova=> select dinheiro+10.25 from prova; ?column? -------- $22.75 $20.25 (2 rows) prova=> select dinero / '1.1'::float from prova; ?column? -------- $11.36 $9.09 (2 rows) prova=> select dinero - 1.1 from prova; ?column? -------- $11.40 $8.90 (2 rows) prova=> select dinero * '1.1'::float from prova; ?column? -------- $13.75 $11.00 (2 rows) ---- ^ ^ OlhO: Be aware that currently isn't possible to CAST a money type to another types. Jose' | | ~~~~~~~~~~~~~~~~~~~~~~~~ | | ~~~~~~~~~~~~~~~~~~~~~~~~ Progetto HYGEA ---- ---- www.sferacarta.com Sfera Carta Software ---- ---- sferac@bo.nettuno.it Via Bazzanese, 69 | | Fax. ++39 51 6131537 Casalecchio R.(BO) Italy | | Tel. ++39 51 591054