max (timestamp,timestamp)

From: T E Schmitz <mailreg(at)numerixtechnology(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: max (timestamp,timestamp)
Date: 2006-11-13 13:46:00
Message-ID: 45587718.2010009@numerixtechnology.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I tried the following query but the query fails as
"function max (timestamp w. timezone,timestamp w. timezone) does not exist"

SELECT id,

MAX(last_updated,
(SELECT MAX (last_updated) FROM product_category_member WHERE
product_category_member.id = product_category.id))

FROM product_category

product_category.last_updated and product_category_member.last_updated
are timestamps with timezone.

Is there any other way I can produce this result

--

Regards,

Tarlika Elisabeth Schmitz

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2006-11-13 14:08:28 Re: max (timestamp,timestamp)
Previous Message A. Kretschmer 2006-11-13 13:22:05 Re: hiding column values for specific rows