On Fri, 28 Mar 2008 00:06:59 -0400,
Tom Lane <[EMAIL PROTECTED]> 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
Seb <[EMAIL PROTECTED]> writes:
>EXTRACT(DAY FROM (table_b.date - table_a.date)) AS age,
> Is this an efficient way to get the days from the time interval? Both
> 'date' columns are of type "Date". Thanks.
Efficiency is moot, it's just plain wrong. Or at least something is
wrong here,
Hi,
I'm not very savvy with interval manipulations, but I have a query like
this:
---<---cut here---start-->---
SELECT DISTINCT ON (table_a.id) table_a.id, table_a.var2,
EXTRACT(DAY FROM (table_b.date - table_a.date)) AS age,
FROM table_a INNER JO
