Is that supposed to be an SQL string, like
"INSERT INTO my_table (field1, field2, field3, field3) VALUES
(0.00,0.00,0.00)"
parentheis -- not curly braces?
Bob Caryl wrote:
> I am using arrays of double precision numbers in certain columns in my
> table. When I format the CString object (analogous to Glib::ustring
> objects in the linux world) to update this column it looks like this:
>
>
> "{0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00}"
>
>
> However, when the odbc driver tries to update the new added record, I
> get the following error message server side (and at my application):
>
> ERROR: invalid input syntax for type double precision:
> "{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}"
>
> Evidently, the odbc driver is deciding to optimize my query perhaps?
> What am I doing wrong this time?
>
> Thanks,
>
> Bob Caryl
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match