pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Duncan Kinder <dckinder@mountain.net>
To: Postgres SQL List <pgsql-sql@postgreSQL.org>
Subject: Money variable
Date: Tue, 12 Oct 1999 15:29:45 -0700
Message-ID: <07ff01bf1501$62342b80$02010101@duncan> (raw)

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







view thread (2+ messages)  latest in thread

Message-ID: <07ff01bf1501$62342b80$02010101@duncan>
Permalink:  ../07ff01bf1501$62342b80$02010101@duncan/
Also on:    postgresql.org/message-id/07ff01bf1501$62342b80$02010101@duncan

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: dckinder@mountain.net
  Subject: Re: Money variable
  In-Reply-To: <07ff01bf1501$62342b80$02010101@duncan>
  References: <07ff01bf1501$62342b80$02010101@duncan>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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