Postgres Pro
Downloads
Home   >   mailing lists

max (timestamp,timestamp) - Mailing list pgsql-sql

From T E Schmitz
Subject max (timestamp,timestamp)
Date
Msg-id 45587718.2010009@numerixtechnology.de
Whole thread Raw
Responses Re: max (timestamp,timestamp)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: hiding column values for specific rows
Next
From: "A. Kretschmer"
Date:
Subject: Re: max (timestamp,timestamp)