I do not understand why I am getting this error.
I have joined the table correctly, is this not sufficient?
forge=> select * FROM generate_series('2016-01-22', '2017-12-31', '1
day'::interval) AS day
LEFT JOIN (
select *, generate_series(c.start_time,
c.end_time, '2 wee
I am creating a small booking system, and need to generate a series of
dates, for the year, with each booking. Using generate_series I can create
the dates, and fill them with a booking date based on the lower tsrange for
the booking.
I need to extend this to also fetch ALL the dates in the tsrange
So far this is what I have.. (see below).
How can I have recurring bookings for a call?
Eg: if the call_frequency is weekly, how can I see a list of dates which
this account will be called upon?
Kind regards
Kevin
CREATE TABLE call_frequency (
id SERIAL PRIMARY KEY NOT NULL,
name
PM, Pavel Stehule
wrote:
> Hi
>
> 2015-12-26 8:28 GMT+01:00 Kevin Waterson :
>
>> I wish to set up a table of recurring, and non-recurring events.
>> I have been looking at
>> http://justatheory.com/computers/databases/postgresql/recurring_events.html
>> which loo
I wish to set up a table of recurring, and non-recurring events.
I have been looking at
http://justatheory.com/computers/databases/postgresql/recurring_events.html
which looks nice (complex but nice) and wonder if there was a better option
for this in more recent pgsql versions.
All pointers grate
