Floating point values are not exact values, there is not guarantee. If you need exact values, use NUMERIC or DECIMAL instead.
Greetings. Walter. On Sat, Jan 2, 2016 at 11:28 AM, Sonya Blade [email protected] [firebird-support] <[email protected]> wrote: > > > > Yes I tried that it wasn't selecting at all, it was due to the floating > point comparison. It seems that hit the wall about that > floating point precision I eliminate that with subtracting the coumns and > taking the absolute value if it is less than 0.000001 epsilon > reference value. > > It worked for now, but I'd like to know what is the decent way of solving > such issues. > > Regards, > > > > hi, > > did you try select instead of update to see if select return all records > which you try to update? > > regards, > Karol Bieniaszewski > > > -------- Oryginalna wiadomość -------- > Od: "Sonya Blade [email protected] [firebird-support]" < > [email protected]> > Data: 02.01.2016 08:24 (GMT+01:00) > Do: [email protected] > Temat: [firebird-support] Update table column from another table > > > > Dear All, > > I have difficulty with updating column records of one table from another > table columns, which have common columns for relation. > Executed query is as follow : > > update elements E set E.END_I = (select n.node_num from nodes N > where (E.X_I =N.XI and E.Y_I = N.YI and E.Z_I=N.ZI) ) > where exists (select 1 from nodes N where (E.X_I =N.XI and E.Y_I = N.YI > and E.Z_I=N.ZI)) > > The problem with that is , not all the columns of Elements are updated, > only one portion is correctly updated and rest > remains intact. I tried to follow instructions here > http://www.firebirdfaq.org/faq323/ but without success. I use old version > of > Firebird which is ver 2.1. > > What is rong with the code above, > > Regards, > > >
