Re: numeric cast oddity

[Sim Zacks <sim@xxxxxxxxxxxxxx>]

It is more then just a headers issue. I have a view that has a column of type numeric(20,4).

I modified the view and added a union which cast an integer as a numeric(20,4) using the :: notation.

I received an error stating that I could not change the column type.

When I used the cast function notation it allowed it through.

The fact that it actually converts it to numeric(20,4) doesn't help me if the view thinks that it is a regular numeric.

Sim

Scott Marlowe wrote:

On Thu, Dec 3, 2009 at 8:03 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
  

Sim Zacks <sim@xxxxxxxxxxxxxx> 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