Re: agregates

From: Eric B(dot)Ridge <ebr(at)tcdi(dot)com>
To: Andrew Sullivan <andrew(at)libertyrms(dot)info>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: agregates
Date: 2003-01-22 22:15:44
Message-ID: 0CFF0F69-2E57-11D7-AFE7-0003937E3354@tcdi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday, January 22, 2003, at 02:28 PM, Andrew Sullivan wrote:

> On Wed, Jan 22, 2003 at 10:07:06AM -0700, David Blood wrote:
>>
>> is there a better way to get the max - 1?
>
> You could try ORDER BY paymentid DESC LIMIT 1 OFFSET 1. That'll give

wouldn't you want LIMIT 2 OFFSET 1 ?

eric

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-01-22 22:18:47 standard schemas for addresses, others?
Previous Message will trillich 2003-01-22 22:11:09 HOW-TO do incomplete dates: year, optional month, optional day?