| From: | "Aaron Bono" <postgresql(at)aranya(dot)com> |
|---|---|
| To: | "operationsengineer1(at)yahoo(dot)com" <operationsengineer1(at)yahoo(dot)com> |
| Cc: | "David Clarke" <pigwin32(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Alternative to serial primary key |
| Date: | 2006-07-07 05:51:14 |
| Message-ID: | bf05e51c0607062251w8f3c853u6032e20aeddb6802@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On 7/7/06, operationsengineer1(at)yahoo(dot)com <operationsengineer1(at)yahoo(dot)com>
wrote:
>
> > Plus I feel I would be remiss in not
> > exploring an
> > alternative to the serial key.
>
> why? it is a tried and true method.
Actually, there are two reasons I think it good for someone new to SQL to
explore this option. First of all, it is very educational. Secondly, it is
the person who stands up and says, "I know everyone does it this way, but
what if we did it that way?" who has a chance of discovering something new.
For this particular topic however, using the serial is very easy and using a
hash is not only error prone but much more difficult.
It is good to see different philosophies about foreign keys though!
-Aaron Bono
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Phillip Smith | 2006-07-07 06:47:24 | Select CASE Concatenation |
| Previous Message | operationsengineer1 | 2006-07-07 05:25:11 | Re: Alternative to serial primary key |