=?iso-8859-2?Q?Egy=FCd_Csaba?= <[EMAIL PROTECTED]> writes: > alumil=# \df addincominginvoice > List of functions > Result data type | Schema | Name | > Argument data types > ------------------+--------+--------------------+--------------------------- > --------------------------------------- > integer | public | addincominginvoice | integer, integer, text, > text, text, text, integer, text, text, text, text, numeric > (1 row)
> 31 17:59:12 SQL Error: PostgreSQL - ERROR: Function > addincominginvoice(integer, integer, "unknown", "unknown", "unknown", > "unknown", integer, "unknown", "unknown", "unknown", "unknown", double > precision) does not exist IIRC, there's no implicit cast from double precision to numeric, only the other direction. You'll need to do something to persuade the ODBC driver to select numeric not float as the parameter type. This is outside my field --- you might get some help in pgsql-odbc. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html