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@sss.pgh.pa.us> wrote:
> Martijn van Oosterhout <kleptog@svana.org> 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
>