an aggregate to return max() - 1 value?

From: Louis-David Mitterrand <vindex+lists-pgsql-sql(at)apartia(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: an aggregate to return max() - 1 value?
Date: 2010-03-04 20:09:14
Message-ID: 20100304200913.GA24865@apartia.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

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

Thanks,

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gerardo Herzig 2010-03-04 20:14:00 Re: an aggregate to return max() - 1 value?
Previous Message Florian Weimer 2010-03-04 10:51:17 Deleting rows from a table not contained in another table