From: | "Duncan Kinder" <dckinder(at)mountain(dot)net> |
---|---|
To: | "Postgres SQL List" <pgsql-sql(at)postgreSQL(dot)org> |
Subject: | Money variable |
Date: | 1999-10-12 22:29:45 |
Message-ID: | 07ff01bf1501$62342b80$02010101@duncan |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)mountain(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Seach | 1999-10-12 23:24:45 | Re: [SQL] Converting column values on a select |
Previous Message | Saltsgaver, Scott | 1999-10-12 21:59:02 | Converting column values on a select |