Scott Marlowe <scott.marlowe@xxxxxxxxx> writes: > On Thu, Dec 3, 2009 at 8:03 AM, Tom Lane <tgl@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
