Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
The topic came up in this other question. We were discussing sign value on a primary key having any significance.
If there are good times to use geometry in building queries the sign value could be somewhat useful. Are there any such times?
For instance I could query rows based on a Doppler pattern, increasingly skipping rows as I get further away from the starting point.
In response to the latitude/longitude data, relational database systems like SQL Server have spatial data types (http://msdn.microsoft.com/en-us/library/bb933876.aspx) which allows you to handle that kind of stuff. You don't really need to skip rows or anything crazy like that to satisfy a need to make stuff "look" right, if that makes any sense. What is it that you're trying to do? Say if rowA is 200 rows away from rowB, then do X?
