On Mar 16, 2013, at 2:05 PM, Csanyi Pal wrote:
> So how can I use this table further eg. to get dates of the school days
> but without Saturdays and Sundays?
You can't do that directly (that kind of calendar operation is outside of the
scope of a range type). You can, however, easily write sel
2013/3/17 Csanyi Pal :
> Hi,
>
> I'm using postgresql 9.2.
>
> I'm trying to figure out how can I use daterange type in my database
> that is supposed to be a school calendar.
>
> I did the followings at the postgresql command prompt:
>
> create database schoolcalendar;
> create table semester_1 (
Hi,
I'm using postgresql 9.2.
I'm trying to figure out how can I use daterange type in my database
that is supposed to be a school calendar.
I did the followings at the postgresql command prompt:
create database schoolcalendar;
create table semester_1 ( schooldays daterange );
insert into semes