Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

bind-address mysql multiple, sanibleone xxxx,, www.xxxcon, which comes first ob_start or session, wwwxxx/58/2010, xxxxdup, xxxxdup, mailx informatii, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?



#1: How can I get leading zeros in my PKey?

Posted on 2006-10-27 15:48:20 by Mark Drummond

SQL/PostgreSQL newb here ... I would like to have a primary key in a
table where the key is numeric, but has a retains leading zeros. The
pkey values should start at:


and increase from there. Is there a data type that will do this for me?
Or should I be storing this as text instead? Or should the leading zeros
be handled outside the database itself, perhaps by the interface?


Report this message