On Sat, Dec 26, 2015 at 03:15:50PM -0500, Tom Lane wrote:
> Gavin Flower writes:
> > The motivation of bottom posting like this: is that people get to see
> > the context before the reply, AND emails don't end up getting longer &
> > longer as people reply at the beginning forgetting to trim the
> On 26 Dec 2015, at 13:03, Kevin Waterson wrote:
>
> Thanks, as I am new to postgres, I was unaware of this function.
Actually, the article you referenced makes use of generate_series as well (at
INSERT INTO events), but then for some reason decides to create a
generate_recurrences function
Gavin Flower writes:
> The motivation of bottom posting like this: is that people get to see
> the context before the reply, AND emails don't end up getting longer &
> longer as people reply at the beginning forgetting to trim the now
> irrelevant stuff at the end.
Of course, this also require
Pleas don't top post - see comment at the bottom of this email.
On 27/12/15 01:03, Kevin Waterson wrote:
Thanks, as I am new to postgres, I was unaware of this function.
To go with this, I guess I will need a table with which to store
intervals, start and end dates?
eg
CREATE table events(
On Sat, Dec 26, 2015 at 23:03:30 +1100,
Kevin Waterson wrote:
Thanks, as I am new to postgres, I was unaware of this function.
To go with this, I guess I will need a table with which to store intervals,
start and end dates?
There is are built in range types that might be more efficiebt for
i
Thanks, as I am new to postgres, I was unaware of this function.
To go with this, I guess I will need a table with which to store intervals,
start and end dates?
eg
CREATE table events(
id serial primary key,
start_timestamp timestamp,
end_timestamp timestamp,
interval
with dateRa
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 looks nice (complex but nice) and wonder if there was a better
> option f
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
