Re: SQL Humor

Tom Ivar Helbekkmo wrote:
> In this situation, I'd be sorely tempted to say "OK, our club will
> have a 'member number' that identifies each member, and I'll use that
> as my primary key for the members table, and Joe Celko can just have a
> coronary if he wants to". :-) (He can also move, or change his name,
> and it won't be a problem.)
>
> Of course, the member number has no physical reality, and it will be
> an automatically assigned serial number (without reuse of defunct
> numbers when people quit or die) -- generally, it seems to be what you
> rant against.

Of course, it has physical reality. What do people mean when they say "I was employee #10 at Waffle corp"? These numbers are imprinted on their badges! Received on Fri Aug 19 2005 - 22:52:47 CEST