On Wed, Nov 06, 2002 at 18:21:08 +0530,
Savita <savita@india.hp.com> wrote:
> Hi ,
>
> I would like to know how to cast as numeric.For examlple
>
> I can use cast as
>
> cast(to_number(substring(os_crm_exchange_call_id, 4), 999999999999) as
> smallint)
::numeric
numeric has 2 option paramters that allow you to limit the precision
and specify a scale. The default is to not limit precision.