Scott Marlowe <scott.marlowe@gmail.com> writes:
> On Thu, Dec 3, 2009 at 8:03 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Really? �Your example doesn't seem to show that.
> I think he's talking about the headers
The headers I get are
regression=# select -1::numeric(20,4);
?column?
----------
-1.0000
(1 row)
regression=# select cast(-1 as numeric(20,4));
numeric
---------
-1.0000
(1 row)
which are indeed different (might be worth looking into why) but
don't seem to have anything to do with scale/precision.
regards, tom lane