Re: Help me with this tricky join - Mailing list pgsql-general

From A. Kretschmer
Subject Re: Help me with this tricky join
Date
Msg-id 20100321074600.GB23565@a-kretschmer.de
Whole thread Raw
In response to Re: Help me with this tricky join  (Jay <josip.2000@gmail.com>)
List pgsql-general
In response to Jay :
> Thanks!
> But, since the master can contain many users (user2, user3, and so on)
> I suppose this won't be a proper solution?
> Sorry if I was a bit unclear in my description.
>
> I.e., the master is of the form:
>
> user_id date
> User1 20010101
> User1 20000101
> User1 19990101
> User1 19970101
> User2 ...
> ...

That's not the problem ...

>
> Btw, I'm using Postgre version 8.2 and I cannot use subqueries do the

but this.
lag() over () and similar windowing functions new since 8.4.



Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: How to dump JUST procedures/funnctions?
Next
From: AI Rumman
Date:
Subject: Re: like operation in tsearch