Re: Money type mapping to backend

From: Byron Nikolaidis <byronn(at)insightdist(dot)com>
To: bill(at)hammondgroves(dot)com
Cc: "pgsql-interfaces(at)hub(dot)org" <pgsql-interfaces(at)hub(dot)org>, "Ken J(dot) Wright" <ken(at)ori-ind(dot)com>, "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
Subject: Re: Money type mapping to backend
Date: 1999-01-08 15:32:43
Message-ID: 3696251B.CAC64C1A@insightdist.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Bill Hutto wrote:

> > Please send the "psqlodbc.log" file of the session. This will show the sql statement
> > as sent to the backend and prove once and for all what the error is. It is hard to
> > make a diagnosis without knowing what really is going wrong.
>
> OK Byron, I've attached the session using data bound controls from
> Visual Basic.
>
> Table Name: visdata
>
> Fields:
> field1 char(40)
> amount money
> quantity int8
>
> If you need any other info, just let me know.
>
>

Hey, guess what, I was testing the whole time under Postgres 6.3 and it does not require the quotes
around money type! Only postgres 6.4 requires the quotes!

That seems kind of weird. Anyone got any comments?

In the meantime, do you have a 6.3 database laying around to try?

Byron

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Stefan Hornburg 1999-01-08 16:00:07 Re: Problems building libpgtcl
Previous Message Bill Hutto 1999-01-08 13:58:10 Re: Money type mapping to backend