Re: When to use name verses id

Lewis,

> Integer IDs are probably also more compact and faster to compare than
> strings, but this effect is not so strong that it should govern your
> decisions. If you don't really need an ID column, I think you're
> better off without one.

A number of database books have long discussions on ID columns, keys,
and how to effeciently identify unique rows. In fact, half the DB and
SQL books on either book page (from www.postgresql.org or from
techdocs.postgresql.org) have such chapters.

Make sure that if you are going to rely on a name column as your unique
value, that you make it your table's Primary Key or at least put a
Unique Index on it. Tables without primary keys are disasters in the
making ...

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco