Scott Marlowe <[email protected]> writes:
> On Thu, Dec 3, 2009 at 8:03 AM, Tom Lane <[email protected]> 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
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
