Re: Some insight on the proper SQL would be appreciated

From: Andy Colson <andy(at)squeakycode(dot)net>
To: Aaron Burnett <aburnett(at)bzzagent(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Some insight on the proper SQL would be appreciated
Date: 2010-06-08 19:16:27
Message-ID: 4C0E970B.9070908@squeakycode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Kupershmidt 2010-06-08 19:56:40 Re: Cognitive dissonance
Previous Message Jeff Amiel 2010-06-08 19:15:28 Re: 3rd time is a charm.....right sibling is not next child crash.