How to use daterange type? - Mailing list pgsql-general

From Csanyi Pal
Subject How to use daterange type?
Date
Msg-id 87li9n2gyz.fsf@gmail.com
Whole thread Raw
Responses Re: How to use daterange type?
Re: How to use daterange type?
List pgsql-general
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 semester_1 values ( '[2012-09-01, 2012-12-24]' );

So how can I use this table further eg. to get dates of the school days
but without Saturdays and Sundays?

--
Regards from Pal

pgsql-general by date:

Previous
From: Oleg Alexeev
Date:
Subject: Re: Addled index
Next
From: Tom Lane
Date:
Subject: Re: Addled index