Re: [GENERAL] PL/PGSQL arithmetic errors

2009-03-30 Thread Justin
Just because a result is unexpected does not mean its an incorrect result.  No postgresql follows the order of operations as expected.  Now looking at the 2 For loops the First does not have a where clause and the Second has  a Where not  null this could be the cause of the problem.  Anothe

[GENERAL] PL/PGSQL arithmetic errors

2009-03-30 Thread jc_mich
Hi all! I'm developing an algorithm with PL/PGSQL using statistical operations from a table. I have several differences between expected results and the results generated by the function. I want to know if there are differences in arithmetic operation sintax or if there's any special arithmetic