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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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?
Thanks,
r.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Stewart | 2002-12-24 00:31:22 | Re: Readline causing grief in build |
Previous Message | Tom Lane | 2002-12-23 19:49:02 | Re: Comma delimited results |