On Sun, Feb 18, 2007 at 12:29:17 +0100, Karsten Hilbert <Karsten.Hilbert@xxxxxxx> wrote: > > The date-of-birth field in our table holding patients is of > type "timestamp with time zone". One of our patient search > queries uses the date-of-birth field to find matches. Since > users enter day, month, and year but not hour, minute, and > second of the DOB we run the query with That seems like an odd choice. Is there some reason they didn't use a type of date? Maybe you could get them to change it?