Postgres Pro
Downloads
Home   >   mailing lists

How to cast as numeric - Mailing list pgsql-general

From Savita
Subject How to cast as numeric
Date
Msg-id 3DC9103C.7A1BEC2E@india.hp.com
Whole thread Raw
In response to i have got an error  (Florian Litot <flitot@besancon.sema.slb.com>)
Responses Re: How to cast as numeric
List pgsql-general
Tree view 
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)
----------------------------------------------------

pgsql-general by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: [SQL] Problem: Referential Integrity Constraints lost
Next
From: Fred
Date:
Subject: out parameters ( oracle 2 pg )