Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DA6EF477465 for ; Thu, 30 Jan 2003 06:56:16 -0500 (EST) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id A8A5647744E for ; Thu, 30 Jan 2003 06:56:15 -0500 (EST) Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50] (may be forged)) by matrix.gatewaynet.com (8.12.5/8.12.5) with ESMTP id h0UG07X0026138; Thu, 30 Jan 2003 14:00:07 -0200 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.5/8.12.5/Submit) with ESMTP id h0UG07aR026134; Thu, 30 Jan 2003 14:00:07 -0200 Date: Thu, 30 Jan 2003 14:00:07 -0200 (GMT+2) From: Achilleus Mantzios To: val@webtribe.net Cc: pgsql-sql@postgresql.org Subject: Re: Delete 1 Record of 2 Duplicate Records In-Reply-To: <20030130115201.D4EB21833A@cheetah.webtribe.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/496 X-Sequence-Number: 11361 On Thu, 30 Jan 2003 val@webtribe.net wrote: > How do I delete only 1 of the duplicate records? Do select oid,* from test where column_id = 5; then choose which oid to delete and do delete from test where oid = ...; > > > column_name | column_id > ---------------------+-------------- > test1 | 5 > test1 | 5 > > > I've tried this: > > tmp_test=# delete from test where column_id = 5 limit 1; > ERROR: parser: parse error at or near "limit" > > I'm using version 7.2.1 > > Thank you. > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > ================================================================== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-10-8981112 fax: +30-10-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr