View

Hello,

I have dates in a database that look something like so :
CREATE TABLE myEvents (
id integer DEFAULT nextval('serial_seq') PRIMARY KEY,
cal_id integer not null
references saa_calendars(id)
on update cascade on delete cascade,
start_date timestamp with time zone NOT NULL DEFAULT now(),
end_date timestamp with time zone NOT NULL DEFAULT now() + interval '1
hour',
summary text NOT NULL DEFAULT '',
description text NOT NULL DEFAULT ''
);

CREATE TABLE myRecurrence (
id integer DEFAULT nextval('serial_seq') PRIMARY KEY,
event_id integer not null
references myEvents(id)
on update cascade on delete cascade,
timeInterval integer not null default '1', -- Number of
weeks/days/months etc
timeSpan text NOT NULL DEFAULT 'day', -- day,week,month etc
limitDate timestamp with time zone NOT NULL DEFAULT now()
);

So I have event bookings, then if they use some kind of recurrence, its
stored in myRecurrence. This has worked fine, since sorting out
recurring dates (creating the duplicate events) is all done client-side
based on these entries.

However now I need the server to be aware of recurring dates. So if an
event is booked, then to recur each month for 5 months, Id have 5
entires show up in my SELECT. I was hoping to wrap this up in a VIEW
however Im at a loss as to how to do it, since its not your typical JOIN
or anything.

Is this possible in a regular VIEW or am I going to need to create a
plpgsql function or some other procedural method of accomplishing this?

Thank you for your time,
- A Gilmore