Re: Using PK value as a String
От | Bill Moran |
---|---|
Тема | Re: Using PK value as a String |
Дата | |
Msg-id | 20080812110416.8e0d6e1c.wmoran@collaborativefusion.com обсуждение исходный текст |
Ответ на | Re: Using PK value as a String (Moritz Onken <onken@houseofdesign.de>) |
Ответы |
Re: Using PK value as a String
|
Список | pgsql-performance |
In response to Moritz Onken <onken@houseofdesign.de>: > We chose UUID as PK because there is still some information in an > integer key. > You can see if a user has registered before someone else (user1.id < > user2.id) > or you can see how many new users registered in a specific period of > time > (compare the id of the newest user to the id a week ago). This is > information > which is in some cases critical. So you're accidentally storing critical information in magic values instead of storing it explicitly? Good luck with that. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ wmoran@collaborativefusion.com Phone: 412-422-3463x4023
В списке pgsql-performance по дате отправления: