I would like to store a temporal frequency as NUMERIC, without units, and have the application's front end (or middleware) transform the number to the appropriate interval name. I'm having difficulties figuring out how to do this. For example, an event might occur once per work shift, day, week, fortnight, or month. For comparison and checking purposes, it would be easier to store a single frequency (e.g., days), but have the users enter and display using other units (for example, a radiobox that presents the units as days or other times). Has this been done before? Or, do I need two columns (frequency and name) and do the conversion to a common time unit behind the scenes? Rich -- Richard B. Shepard, Ph.D. | The Environmental Permitting Applied Ecosystem Services, Inc. | Accelerator(TM) <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
