Home > mailing lists

an aggregate to return max() - 1 value? - Mailing list pgsql-sql

From	Louis-David Mitterrand
Subject	an aggregate to return max() - 1 value?
Date	March 4, 2010 16:09:28
Msg-id	20100304200913.GA24865@apartia.fr Whole thread Raw
Responses	Re: an aggregate to return max() - 1 value? Re: an aggregate to return max() - 1 value? Re: an aggregate to return max() - 1 value?
List	pgsql-sql

Hi,

With builtin aggregates is it possible to return the value just before
max(col)?

Thanks,

From: Florian Weimer
Date: 04 March 2010, 06:57:02
Subject: Deleting rows from a table not contained in another table

From: Rob Sargent
Date: 04 March 2010, 16:18:54
Subject: Re: an aggregate to return max() - 1 value?