Re: [Q] specifying bigint

V S P wrote:
> HI,
> I did some more tracing, and it looks like the data is sent to ODBC
> correctly  (bigint, char, bigint)
> and it is somewhere within ODBC driver or after, bigints are converted
> to strings
> Wanted to ask if there is may be a workaround of some sort to keep
> bigints
> as number not strings
>
>
> here is the ODBC trace of the offending update (Ascii driver on windows)
> the bigint appear to be 'announced' as bigints
> (prb_bigint is my program name)
>
> The error indicates, however that somewhere bigint is converted to a
> string
> in 'f3=t.f3"
>
>     DIAG [42883] ERROR: operator does not exist: bigint = text;
> Error while executing the query (7)
>
>
> ------------------------
> prb_bigint      d98-110 ENTER SQLPrepare
>         HSTMT               00921C28
>         UCHAR *             0x009078F0 [      -3] "UPDATE test_tab SET f2= t.f2,f3=t.f3 from(VALUES( ?          , ?
        , ?          ))as t(f1,f2,f3) WHERE test_tab.f1=t.f1\ 0" 
>         SDWORD                    -3

How about
   UPDATE test_tab SET f2=t.f2, f3=t.f3 from (VALUES (?::bigint, ?,
   ?::bigint)) as t(f1,f2,f3) WHERE test_tab.f1=t.f1
?

regards,
Hiroshi Inoue