How to cast as numeric

From: Savita <savita(at)india(dot)hp(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to cast as numeric
Date: 2002-11-06 12:51:08
Message-ID: 3DC9103C.7A1BEC2E@india.hp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

but here I will have the restriction of the field so If I want to cast it as
numeric how
do I do that.
--
Best Regards
- Savita
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)
----------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Achilleus Mantzios 2002-11-06 12:53:21 Re: [SQL] Problem: Referential Integrity Constraints lost
Previous Message Achilleus Mantzios 2002-11-06 12:41:52 Problem: Referential Integrity Constraints lost