tom- did you test this on wndows? you can ignore the namespace- i'm using it consistently but removed from the test code to simplify this problem occurs repeatedly in my code. my guess is that it's a bug in the windows build. On Nov 30, 2007 8:13 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Martijn van Oosterhout <kleptog@xxxxxxxxx> writes: > > On Fri, Nov 30, 2007 at 12:23:31AM -0800, Postgres User wrote: > >> However, I have found that my record variable is not assigned proper > >> field-level datatypes. As a result, I'm unable to write basic math > >> calcs in pg/sql without a lot of typecasting. > > > What version are you running. On my 8.1.9 test system it returns -1.00 > > as expected. > > Works for me too, in all branches back to 8.0. However, I noticed that > the test function references "test.table2" not just "table2", which > makes me wonder if maybe this is picking up some other table2 than the > OP thinks. A test.table2 with integer columns would explain the result. > > regards, tom lane > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
