Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 1848A475A3F
	for <pgsql-sql@postgresql.org>; Thu, 30 Jan 2003 06:52:03 -0500 (EST)
Received: from klingon.netkonect.net (klingon.netkonect.co.uk [194.62.44.61])
	by postgresql.org (Postfix) with ESMTP id D2AAA4758E6
	for <pgsql-sql@postgresql.org>; Thu, 30 Jan 2003 06:52:01 -0500 (EST)
Received: from cheetah.webtribe.net (cheetah.webtribe.net [194.164.194.4])
	by klingon.netkonect.net (8.11.4/8.11.4) with ESMTP id h0UBq2N24418
	for <pgsql-sql@postgresql.org>; Thu, 30 Jan 2003 11:52:02 GMT
Received: from localhost (cheetah.webtribe.net [194.164.194.4])
	by cheetah.webtribe.net (Postfix) with SMTP id D4EB21833A
	for <pgsql-sql@postgresql.org>; Thu, 30 Jan 2003 11:52:01 +0000 (GMT)
Cc: 
Subject: Delete 1 Record of 2 Duplicate Records
Content-type: text/plain
X-mailer: WebMail 
Date: Thu, 30 Jan 2003 11:52 +0000
Content-transfer-encoding: 8bit
Mime-version: 1.0
To: pgsql-sql@postgresql.org
From: val@webtribe.net
Message-Id: <20030130115201.D4EB21833A@cheetah.webtribe.net>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/495
X-Sequence-Number: 11360

How do I delete only 1 of the duplicate records?


 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.