Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A23FA475925 for ; Sun, 5 Jan 2003 05:24:22 -0500 (EST) Received: from jobs1.unisoftbg.com (unknown [194.12.229.208]) by postgresql.org (Postfix) with SMTP id 33EBA4758DC for ; Sun, 5 Jan 2003 05:24:20 -0500 (EST) Received: (qmail 396 invoked from network); 5 Jan 2003 12:04:48 -0000 Received: from unisoft.unisoftbg.com (HELO t1.unisoftbg.com) (194.12.229.193) by 0 with SMTP; 5 Jan 2003 12:04:48 -0000 Message-ID: <3E17FA4B.7F4102B6@t1.unisoftbg.com> Date: Sun, 05 Jan 2003 10:26:35 +0100 From: pginfo X-Mailer: Mozilla 4.03 [en] (Win95; I) MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: Deleting in order from a table Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/28 X-Sequence-Number: 10893 Hi , I think the question is stupied, but it is importand for me. I have a table tableA ( ....,order_num int). I will to delete some records from tableA but in asc or desc order_num-order. Is it possible to write delete from tableA where (some conditions) order by order_num ? Many thanks, ivan.