Re: [GENERAL] numeric cast oddity

Thu, 03 Dec 2009 07:56:22 -0800

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 <[email protected]> wrote:
  
Sim Zacks <[email protected]> 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

Reply via email to