On Fri, 28 Mar 2008 00:06:59 -0400, Tom Lane <tgl@xxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
