Re: join on next row

From: "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com>
To: "Aaron Evans" <aaron(at)aarone(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: join on next row
Date: 2006-06-22 14:43:04
Message-ID: 65937bea0606220743v1fc8357bkacedbcf3fa04ef31@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks for pointing it out.... You are right; I forgot to add that...

On 6/20/06, Aaron Evans <aaron(at)aarone(dot)org> wrote:
>
> sorry to nitpick, but I think that to get this query to do exactly
> what you want you'll need to add ordering over EventTime on your sub-
> selects to assure that you get the next event and not just some event
> later event on the given day.
>
> -ae
>
> On Jun 20, 2006, at 11:12 AM, Gurjeet Singh wrote:
>
> > Gurjeet Singh wrote:

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma Jr 2006-06-22 14:53:33 Re: OLEDB Provider for Postgres
Previous Message Alejandro Michelin Salomon ( Adinet ) 2006-06-22 14:37:58 Download pl/python