Thomas Lockhart writes: > Oh yeah. We don't have a date_part(units, time) function defined, so it > is getting converted to interval (which in other contexts *does* have > some usefulness as a "time equivalent").
You're going to have an extremely hard time convincing me of that. > We could fairly easily define a date_part() for the time and timetz data > types. I had figured that time would be cast to timestamp. Which is probably what it used to do. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly