8.2 / Windows (a development-only pc) On Nov 30, 2007 12:50 AM, Martijn van Oosterhout <kleptog@xxxxxxxxx> wrote: > 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. > > Have a nice day, > -- > Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > > Those who make peaceful revolution impossible will make violent revolution inevitable. > > -- John F Kennedy > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.1 (GNU/Linux) > > iD8DBQFHT87KIB7bNG8LQkwRAuzqAJ9jdaDv/rxz5pG8bdYvO9suxZLGZACeL6BY > ZMvLJ5nKREBIsBrdk4nE748= > =/aEm > -----END PGP SIGNATURE----- > > ---------------------------(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
