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