Re: PostgreSQL ODBC connection from Crystal reports in windows, currency domain - Mailing list pgsql-odbc

On Mon, 2009-03-09 at 15:07 +0000, Peter Geoghegan wrote:
> Hello,
>
> I'm attempting to get Crystal reports working with PostgreSQL with an
> ODBC connection, via psqlODBC. I can successfully establish the
> connection easily. However, I have a domain called "currency", that
> handles currency values:
>
> CREATE DOMAIN currency
>   AS numeric(10,2);
> ALTER DOMAIN currency OWNER TO manager;
>
> fields of currency appear as "strings" in Crystal reports, and they
> lack fixed precision ( the value 1.00 appears as 1, for example). Why
> might this be? How can I get it to appear as a numeric type, which I
> can find the sum of, etc?

Just use numeric and don't create a domain?

Joshua D. Drake


>
> Thanks,
> Peter Geoghegan
>
--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997