Incrementing a date type.

From: "DC" <danc(at)bspmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Incrementing a date type.
Date: 2001-05-18 17:17:47
Message-ID: 9e3ljh$g10$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have an event that is three days long. In a table I want to be able to
enter Friday date and have Saturdays and Sundays fill in automatically. It
also has to check for the month/# of days in...
Example
input : Friday=6-1-2001
autoadd: Saturday=6-2-2001
autoadd: Sunday=6-3-2001

Example 2
input: Friday=June 29
autoadd: Saturday=June 30
autoadd Sunday=July 1

If this can not be done easily (as I'm no expert) please advise.
The reason I would like to do this automatically is to eliminate errors.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Smith 2001-05-18 17:32:21 Vacuum Failed - backend closed the channel unexpectedly
Previous Message Morten Primdahl 2001-05-18 16:55:57 Re: ER diagram generator