Re: [Gnumed-devel] Measurements - adding and abbreviations

[Karsten Hilbert]

On Mon, Aug 01, 2011 at 01:54:48PM -0700, Jim Busser wrote:

> > Please suggest a saner source of the time when no time is
> > provided.
> 
> I suppose there is in postgres no field that
> 
>       requires date to be provided (but may optionally allow null)
> 
>       accepts a time portion (if inputted) but able to optionally allow a 
> null time portion
> 
> ??

Not built-in:

        http://www.postgresql.org/docs/9.1/static/datatype-datetime.html

One would need to (but could) create a composite data type.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346