Re: Some insight on the proper SQL would be appreciated - Mailing list pgsql-general

From Andy Colson
Subject Re: Some insight on the proper SQL would be appreciated
Date
Msg-id 4C0E970B.9070908@squeakycode.net
Whole thread Raw
In response to Some insight on the proper SQL would be appreciated  (Aaron Burnett <aburnett@bzzagent.com>)
List pgsql-general
On 6/8/2010 2:08 PM, Aaron Burnett wrote:
>
> thanks very much Andy. Very elegant.
>
> I do need to presere the users that have<5 entries though, so I think I can
> modify your function to do that as well.
>
> Thanks again.
>
>

Oh, duh!  because nothing is less than 1900-01-01...  my date math
sucks.  It should probably return '2100-01-01' or something.

-Andy

pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: Some insight on the proper SQL would be appreciated
Next
From: Jeff Amiel
Date:
Subject: Re: 3rd time is a charm.....right sibling is not next child crash.