Re: numeric cast oddity

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:

<blockquote
 cite="mid:dcc563d10912030749r2bc35040qd42da5b29c37193f@mail.gmail.com"
 type="cite">
  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