# Converting decimal primary key to integer (oracle)

**URL:** <https://www.ruby-forum.com/t/converting-decimal-primary-key-to-integer-oracle/50002>\
**Category:** Rails\
**Created:** [December 11, 2005, 11:00pm UTC](https://www.ruby-forum.com/t/converting-decimal-primary-key-to-integer-oracle/50002 "2005-12-11T23:00:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dmcclean](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/91b2a8/32.png) [@dmcclean](https://www.ruby-forum.com/u/dmcclean)\
**Post date:** [December 11, 2005, 11:00pm UTC](https://www.ruby-forum.com/t/converting-decimal-primary-key-to-integer-oracle/50002/1 "2005-12-11T23:00:17Z")

</div>

I am working with a legacy oracle database. The  
primary key is not defined as an integer but as a number.  
This results in a url with an id as a number, such as 1234.0 instead  
of 1234. It works fine, but I would prefer 1234 to be displayed in  
the url. I have attempted to redefine the model id method to  
convert to an integer using to\_i method, but no luck. Any ideas?

Thanks,  
DOn

---

<div class="post-metadata">

**Author:** ![dmcclean](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/91b2a8/32.png) [@dmcclean](https://www.ruby-forum.com/u/dmcclean)\
**Post date:** [April 6, 2009, 10:09am UTC](https://www.ruby-forum.com/t/converting-decimal-primary-key-to-integer-oracle/50002/2 "2009-04-06T10:09:30Z")

</div>

I am also having the same prob plz help me if u get the solution…  
thanks,  
vaibhav