Received: from venkat.vxl.co.in ([202.54.39.170]) by hub.org (8.9.3/8.9.3) with ESMTP id GAA84643 for ; Fri, 19 Nov 1999 06:04:57 -0500 (EST) (envelope-from imtiaz_sm@yahoo.com) Received: from yahoo.com (root@localhost [127.0.0.1]) by venkat.vxl.co.in (8.8.7/8.8.7) with ESMTP id QAA12814 for ; Fri, 19 Nov 1999 16:37:24 +0530 Sender: root@venkat.vxl.co.in Message-ID: <38352F68.FB6DDC78@yahoo.com> Date: Fri, 19 Nov 1999 16:37:21 +0530 From: "Imtiaz. S. M" Organization: VXL Instruments Ltd. X-Mailer: Mozilla 4.07 [en] (X11; I; Linux 2.0.36 i686) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Deleting rows with time 55 minutes less than max time Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I have a table which contains a single datetime column along with other columns. Now I want to delete all the rows with datetime values 55 minutes less(in the datetime column) than the maximum datetime value present in the datetime column. How do I achieve this? I have tried all possibile methods which I know of. Still could not achieve this. Thanks in advance. regards Imitaz