Received: from capitular.tissat.es (capitular.tissat.es [195.77.30.34]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA44153; Thu, 2 Sep 1999 04:32:30 -0400 (EDT) (envelope-from echiner@tissat.es) Received: from tissat.es ([195.77.30.15]) by capitular.tissat.es (Netscape Messaging Server 3.6) with ESMTP id AAA6614; Thu, 2 Sep 1999 10:31:55 +0200 Message-ID: <37CE3592.2558E205@tissat.es> Date: Thu, 02 Sep 1999 10:30:10 +0200 From: "Esteban Chiner Sanz" X-Mailer: Mozilla 4.5 [es] (WinNT; U) X-Accept-Language: es MIME-Version: 1.0 To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Max function on Timestamp Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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@tissat.es TISSAT Av. Aragon, 30, 5ª planta Phone: 96 393 9950 Valencia (SPAIN)