Max function on Timestamp

From: "Esteban Chiner Sanz" <echiner(at)tissat(dot)es>
To: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Max function on Timestamp
Date: 1999-09-02 08:30:10
Message-ID: 37CE3592.2558E205@tissat.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

I have a table in my database with a timestamp field and I can't use a
max function on it. You can do it with any other date types (date,
timespan, etc.) but not with timestamp.
Is there any problem on doing it? Why isn't it implemented in PostgreSQL
6.5.1? What would be the easiest way of doing it?
Thank you in advance,

Esteban Chiner

P.D: There aren't also any "less than" or "greater than" operators on
timestamp...

------------------------------------------------------------
Esteban Chiner Sanz mailto (work): echiner(at)tissat(dot)es
TISSAT
Av. Aragon, 30, 5ª planta Phone: 96 393 9950
Valencia (SPAIN)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Natalya S. Makushina 1999-09-02 08:45:16 GEQO and KSQO problem.
Previous Message Holger Klawitter 1999-09-02 08:21:07 backend crashes

Browse pgsql-sql by date

  From Date Subject
Next Message Clayton Cottingham 1999-09-02 09:59:47 Re:
Previous Message elca 1999-09-02 08:07:15 보시면인생이달라질지도 =?EUC-KR?B?uPC4p7TPtNk=?=.. :-))