Results 1 to 2 of 2
Jul 28, 2005, 05:57 #1
zero fill allowed on postgres integer field?
Does anyone know if it's possible to store numbers like 00034565 in an integer field in postgres 8 ?
Jul 28, 2005, 16:51 #2
- Join Date
- Jul 2002
- Toronto, Canada
- 60 Post(s)
- 3 Thread(s)
i can't see why not, that sure looks like a valid integer value to me
although to display it the way you want, you may have to convert the integer value to a string, concatenate a bunch of character 0's to the left of the value, then use the RIGHT function to pull out the correct number of characters