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
