Robert Haas <robertmh...@gmail.com> writes: > Sure, but the point is that 5.0000 is not the same as 5.000 today. If > you start whacking this around you'll be changing that behavior, I > think.
Yeah. And please note that no matter what the OP may think, a lot of people *do* consider that there's a useful distinction between 5.000 and 5.0000 --- it might indicate the number of significant digits in a measurement, for example. I do not see us abandoning that just to make certain cases of ALTER TABLE faster. There was some upthread discussion about somehow storing the scale info at the column level rather than the individual-datum level. If we could do that, then it'd be possible to make this type of ALTER TABLE fast. However, the work involved to do that seems enormously out of proportion to the benefit, mainly because there just isn't any convenient way to trace a Datum to its source column, even assuming it's got one. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers