Re: numeric cast oddity - Mailing list pgsql-general

From Scott Marlowe
Subject Re: numeric cast oddity
Date
Msg-id dcc563d10912030749r2bc35040qd42da5b29c37193f@mail.gmail.com
Whole thread Raw
In response to Re: numeric cast oddity  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: numeric cast oddity  (Sim Zacks <sim@compulab.co.il>)
Re: numeric cast oddity  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Thu, Dec 3, 2009 at 8:03 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Sim Zacks <sim@compulab.co.il> writes:
>> When I cast an integer to numeric using :: notation it ignores the scale
>> and precision that I specify, but when I use the cast function it uses
>> the scale and precision that I specify.
>
> Really?  Your example doesn't seem to show that.

I think he's talking about the headers

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Catastrophic changes to PostgreSQL 8.4
Next
From: Craig Ringer
Date:
Subject: Re: [Bacula-users] Catastrophic changes to PostgreSQL 8.4