From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Roger Tannous <roger77_lb@yahoo.com>
Cc: PostgreSQL SQL Mailing List <pgsql-sql@postgresql.org>
Subject: Re: Generating dates prior to generate_series
Date: Thu, 05 Apr 2007 10:24:26 -0500
Message-ID: <1175786666.9839.33.camel@state.g2switchworks.com> (raw)
In-Reply-To: <580286.82124.qm@web90602.mail.mud.yahoo.com>
References: <580286.82124.qm@web90602.mail.mud.yahoo.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: smarlowe@g2switchworks.com, roger77_lb@yahoo.com
Subject: Re: Generating dates prior to generate_series
In-Reply-To: <1175786666.9839.33.camel@state.g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox