Skip site navigation (1) Skip section navigation (2)

money type

From: "Reshat Sabiq" <sabiq(at)purdue(dot)edu>
To: "'pgsql-novice'" <pgsql-novice(at)postgresql(dot)org>
Subject: money type
Date: 2002-12-23 21:59:14
Message-ID: 000101c2aace$8baef880$2085d380@main (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Is there any config setting that can make queries like

Select * from money_field where cost > 25

be valid in postgreSQL? I guess not, but just want to make sure. Since I
want my code to stay the same between Access, Oracle, and postgreSQL,
that leaves me only one option (suggested by docs too): convert currency
types in other DBs into numeric in postgres. 

P.S. I guess I don't have an option to select numeric(10, 2) or the like
in pgAdmin, however. It has to be just numeric... Am I right? Is it
possible to alter table afterwards?


In response to

pgsql-novice by date

Next:From: Dave StewartDate: 2002-12-24 00:31:22
Subject: Re: Readline causing grief in build
Previous:From: Tom LaneDate: 2002-12-23 19:49:02
Subject: Re: Comma delimited results

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group