"Brian C. DeRocher" <[EMAIL PROTECTED]> writes: > It appears that when you create a view of a union, numeric data types > loose their scale and precision.
I think this is the same issue discussed here: http://archives.postgresql.org/pgsql-hackers/2004-12/msg00408.php That was just before 8.0 release, so the change got postponed and then seems to have slipped through the cracks :-(. Any objections to fixing it for 8.2? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings