Received: from Namesrv.Mountain.Net (root@Namesrv.Mountain.Net [198.77.1.1]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA40388 for ; Tue, 12 Oct 1999 15:49:46 -0400 (EDT) (envelope-from dckinder@mountain.net) Received: from duncan (AM6-15.Wheeling-WV.Mountain.Net [198.77.41.115]) by Namesrv.Mountain.Net (8.9.3/8.9.0) with SMTP id PAA07449 for ; Tue, 12 Oct 1999 15:49:42 -0400 (EDT) Message-ID: <07ff01bf1501$62342b80$02010101@duncan> From: "Duncan Kinder" To: "Postgres SQL List" Subject: Money variable Date: Tue, 12 Oct 1999 15:29:45 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 I am attempting to enter values for a database used by the book "The Practical SQL Handbook," (Bowman, et.al, Addison-Wesley, 1996). This book, using SQL Anywhere, uses a "bookbiz" database, with a "titles" table. "Tables" includes, among other things, two fields "price" and "advance" which use the money variable. I am attempting to enter this data into Postgres. I cannot enter data into these fields in Postgres. When entering "$20.00" for price I get the following: "error near '.00'. When entering "$20" I get "out of range." and when entering "20.00" I get " attribute 'price' is of type'money' but expression is of type 'float8'. You will have to rewrite or cast the expression. I have drooped and re-created the table. I have attempted to enter this data numerous times. No luck. How do I enter money data in Postgres? Regards, Duncan C. Kinder dckinder@mountain.net