Re: Strange Update query ... - Mailing list pgsql-odbc

From Hélder M. Vieira
Subject Re: Strange Update query ...
Date
Msg-id 000a01c6564a$da5e2750$580bfea9@hmv02
Whole thread Raw
In response to Strange Update query ...  (Thomas Chabaud <tc@geosys.fr>)
List pgsql-odbc
Hiroshi, I made several tests, and the log always shows an UPDATE statement
filled with constant values, such as:

'UPDATE mytable SET myfield1=4,myfield2=5,myfield3=6
WHERE (id=6 AND myfield1=1 AND myfield2=2 AND myfield3=3 )'

I tried with several data types, with and without explicit declaration of
the 'myvaluex' variables, and never saw variable names in the generated
UPDATE statement.

Thomas Chabaud's log shows:

'UPDATE mytable SET myfield1=myvalue1,myfield2=myvalue2,myfield3=myvalue3
WHERE (id=6 AND myfield1=myvalue1 AND myfield2=myvalue2 AND
myfield3=myvalue3 )'

I can't figure out how variable names could appear in the UPDATE statement,
so I think Thomas Chabaud should provide some information about the nature
of those variables.


Hélder M. Vieira



pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Strange Update query ...
Next
From: Bruce Momjian
Date:
Subject: Re: problem about maximum row size ?