=?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

Reply via email to