Home > mailing lists

Delete Question - Mailing list pgsql-general

From	Alex
Subject	Delete Question
Date	December 7, 2005 06:21:29
Msg-id	43968D75.6020804@meerkatsoft.com Whole thread Raw
Responses	Re: Delete Question Re: Delete Question Re: Delete Question Re: Delete Question
List	pgsql-general

Tree view

Hi,

I have a table where I store changes made to an order. The looks like
ProdID, ChangeDate, Change1, Change2, ... etc.
Some ProdIDs have multiple records.

Is there an easy way to delete all records of a ProdID except the most
recent (ChangeDate is timestamp) one? Preferably in one SQL statement?

Thanks for any advise

Alex

pgsql-general by date:

From: "A.j. Langereis"
Date: 07 December 2005, 05:20:27
Subject: Re: Letting a function return multiple columns instead of a single complex one

From: Emil Rachovsky
Date: 07 December 2005, 06:26:06
Subject: Re: [SQL] lost in system tables

Delete Question - Mailing list pgsql-general

Previous

Next