On Fri, 28 Mar 2008 00:06:59 -0400,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
[...]
> Efficiency is moot, it's just plain wrong. Or at least something is
> wrong here, Subtraction of two "date" values gives an integer number
> of days already, so I'd expect the EXTRACT to fail altogether. You
> sure the date columns are type date and not type timestamp?
My mistake, yes, sure they're both timestamp!
--
Seb