no keys...

From: "Dorward Villaruz" <dorwardv(at)ntsp(dot)nec(dot)co(dot)jp>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: no keys...
Date: 2002-04-16 19:31:15
Message-ID: 000d01c1e57d$47267560$043d1cac@speed
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i have a table where there is no primary key

i have 5 rows of data

day1 time1
day1 time1
day1 time2
day1 time2
day1 time2

time2 is newer than time1, how should i delete the four oldest record in the table. this means that the only row that will be left on my table is:

day1 time2

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2002-04-16 20:18:02 Re: Mass-Data question
Previous Message Jeff Eckermann 2002-04-16 19:24:50 Re: Java as PG Procedural Language