Received: from mail01.phoenixdsl.com (mail.phoenixdsl.com [216.178.151.24]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0VF0fq43910 for ; Wed, 31 Jan 2001 10:00:41 -0500 (EST) (envelope-from mdavis@sevainc.com) Received: (qmail 85640 invoked by uid 89); 31 Jan 2001 15:00:37 -0000 Received: from unknown (HELO SALLY) (64.32.157.45) by 0 with SMTP; 31 Jan 2001 15:00:37 -0000 Received: by localhost with Microsoft MAPI; Wed, 31 Jan 2001 08:00:36 -0700 Message-ID: <01C08B5B.E4F77000.mdavis@sevainc.com> From: Michael Davis Reply-To: "mdavis@sevainc.com" To: "'Padmajha Raghunathan'" , "pgsql-sql@postgresql.org" Subject: RE: Rownum/ row Id Date: Wed, 31 Jan 2001 00:32:05 -0700 Organization: Seva Inc. X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/476 X-Sequence-Number: 1152 The column name is OID. -----Original Message----- From: Padmajha Raghunathan [SMTP:padmajha@easi.soft.net] Sent: Tuesday, January 30, 2001 11:20 PM To: pgsql-sql@postgresql.org Subject: Rownum/ row Id Hi, Is there a provision to delete the duplicate records using row num/ row id as available in Oracle??? Thanx in advance padmajha