Andy Colson wrote on 29.04.2010 23:51:
Here is my query, which works:
select organization,
state,
(select max(idate) from times where customers.custid=times.custid and
taskid = 27) as lastdate,
age( (select max(idate) from times where customers.custid=times.custid
and taskid = 27) )
from customers
order by lastdate desc nulls last;
I'd love to use age(lastdate) instead of age( (repeat sql) ), but it
does not seem to work.
This should work:
SELECT organization, state, lastdate, age(lastdate)
FROM (
SELECT organization,
state,
(select max(idate) from times where customers.custid=times.custid and
taskid = 27) as lastdate
FROM customers
) t
order by lastdate desc
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
