[GENERAL] How to use daterange type?

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

[GENERAL] ERROR: relation employees does not exist

Hi, I just installed Postgresql 9.2 on my Debian Wheezy system. I want to study and learn about new data type, the range type. I'm following the tutorial: https://wiki.postgresql.org/images/7/73/Range-types-pgopen-2012.pdf but when I run the command: CREATE TABLE employee_schedule ( id