> >What I am grappling with is how to keep the co-ordinate pair >"atomic". If I used separate fields for the latitude and >longitude, an unknown point would have two nulls, a known >point two values ... one of each would be "verboten", and hard >to protect against using normal check constraints (or maybe >I'm just having a senior moment). I vote for senior moment. :) Use a check constraint on the table: (latitude is not null and longitude is not null) or (latitude is null and longitude is null). Of course, if you were storing true historical data, only knowing the latitude would be perfectly correct. (But I digress...) -- //www.freelists.org/webpage/oracle-l