From: Dino Vliet <dino_vliet@yahoo.com>
To: pgsql-general@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: help with trigger
Date: Fri, 27 Aug 2004 12:35:42 -0700 (PDT)
Message-ID: <20040827193542.91778.qmail@web40101.mail.yahoo.com> (raw)
Maybe I've missed it but can someone plese help me
with this?
Brgds and thanks in advance,
--- Dino Vliet <dino_vliet@yahoo.com> wrote:
> Hi folks,
> I'm new to PostgreSQL and am busy tring to work with
> it. Of pl/pgsql I know even less and that's the part
> I
> have a question on right now. I have this nice
> example
> to get me started with
> pl/pgsql.......
>
> I have a table with the schedule of a service my
> sport
> team wants to offer:
>
> Table Schedule
> name length startdate enddate day
> soccer 4 01-sep-2004 30-sep-2004
> Mon
> tennis 4 01-sep-2004 30-sep-2004
> Wed
>
> This means, that I want to offer soccer weekly, for
> a
> total of 4 weeks as from 1st sep till 30 sep on
> Mondays!
>
> Now, what I do want is a second table that creates
> all
> the dates on which there will be soccer training if
> I
> finish entering this record in table Schedule. So,
> then the other table, called ScheduledDates has the
> follwing records:
>
> Table ScheduleDates
> name occurrence date
> soccer 1 06-sep-2004
> soccer 2 13-sep-2004
> soccer 3 20-sep-2004
> soccer 4 27-sep-2004
>
> Can someone help me with writing this as a trigger
> in
> pl/pgsql?
>
> Another variant is that the trigger starts when the
> table Schedule is populated, but it not just
> automatically creates the 4 records as described
> above, but because the date 20-sep-2004 is a
> national
> holiday and is in table Exceptions, the sheme just
> shifts one up and the occurrence 4 becomes
> occurrence
> 3 and the last schedule date becomes monday the 4th
> of
> october!
>
> I hope you can help me with this one, will put me
> way
> up the learning curve of pl/pgsql
>
>
>
>
> __________________________________
> Do you Yahoo!?
> New and Improved Yahoo! Mail - 100MB free storage!
> http://promotions.yahoo.com/new_mail
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
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: dino_vliet@yahoo.com, pgsql-general@postgresql.org
Subject: Re: help with trigger
In-Reply-To: <20040827193542.91778.qmail@web40101.mail.yahoo.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