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