Postgres Pro
Downloads
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
Msg-id 20100304200913.GA24865@apartia.fr
Whole thread Raw
Responses Re: an aggregate to return max() - 1 value?  (Rob Sargent <robjsargent@gmail.com>)
Re: an aggregate to return max() - 1 value?  (Gerardo Herzig <gherzig@fmed.uba.ar>)
Re: an aggregate to return max() - 1 value?  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-sql
Tree view 
Hi,

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

Thanks,

pgsql-sql by date:

Previous
From: Florian Weimer
Date:
Subject: Deleting rows from a table not contained in another table
Next
From: Rob Sargent
Date:
Subject: Re: an aggregate to return max() - 1 value?