| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Roger Tannous <roger77_lb(at)yahoo(dot)com> |
| Cc: | PostgreSQL SQL Mailing List <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Generating dates prior to generate_series |
| Date: | 2007-04-05 15:24:26 |
| Message-ID: | 1175786666.9839.33.camel@state.g2switchworks.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Wed, 2007-04-04 at 07:00, Roger Tannous wrote:
> I'm using PostgreSQL version 7.3.2, and generate_series() is not
> available, so this is a function to generate a series dates.
>
> The function goes backwards if the second argument is less than the first
> one. Check the two select statements at the end.
As someone who is still responsible for the care and feeding of a 7.4
database, thanks for the function.
You really should upgrade to the latest 7.3.xx version, as there were
many data loss bugs in earlier 7.3.xx versions that have been fixed.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gary Stainburn | 2007-04-05 16:03:04 | SOLVED - Another date range join problem |
| Previous Message | Tom Lane | 2007-04-05 15:20:46 | Re: LOG: unexpected EOF on client connection |