Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

Catastrophic failure Unexpected method call sequence. 0x8000ffff (-2147418113)., ksh lock a file, [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed, sed: -e expression #1, char 1: unterminated address regex, procmail + change subject, w2ksp4.exe download, /proc/kallsyms format, sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm

Links

XODOX
Impressum

#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:

00000001

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?

Thanks,
Mark

Report this message