Postgres Pro
Downloads
Home   >   mailing lists

no keys... - Mailing list pgsql-general

From Dorward Villaruz
Subject no keys...
Date
Msg-id 000d01c1e57d$47267560$043d1cac@speed
Whole thread Raw
Responses Re: no keys...  (Jeff Davis <list-pgsql-general@empires.org>)
List pgsql-general
Tree view
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
 
 
 

pgsql-general by date:

Previous
From: Jason Earl
Date:
Subject: Re: timestamped archive data index searches
Next
From: Ralph Graulich
Date:
Subject: Re: size of function body