Skip site navigation (1) Skip section navigation (2)

Re: To get a Table or View like a Calendar with dates

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Csanyi Pal" <csanyipal(at)gmail(dot)com>,<pgsql-novice(at)postgresql(dot)org>
Subject: Re: To get a Table or View like a Calendar with dates
Date: 2012-08-06 16:08:36
Message-ID: 501FA5B40200002500049436@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-novice
Csanyi Pal <csanyipal(at)gmail(dot)com> wrote:
 
> The database should store the data like dates of the beginning and
> the end of the school year, holidays, non school days, various
> events, etc.
> 
> I want to get a Table or a View which I can use as a School
> Calendar with school days, and non school days too, and much more.
> 
> I have created Tables with dates of the beginning date and the end
> date of the school year. 
> 
> I have Table with dates of holidays and/or non school days in the
> school year too.
> 
> Can I create a Table or a View from these Tables to get such a
> school calendar? 
 
Yes, it sounds like the set of tables you describe could support a
great many useful queries, and you could encapsulate these in views
to make them easier to use.
 
Are you having some problem doing so?  What have you tried?  What
did you expect to happen?  What happened instead?
 
-Kevin

In response to

Responses

pgsql-novice by date

Next:From: Antonio Carlos Salzvedel Furtado JuniorDate: 2012-08-07 22:05:51
Subject: Performance issue with virtualized DB
Previous:From: Day, DavidDate: 2012-08-06 12:01:44
Subject: Re: Pgadmin3 v1.14.2 foreign keys

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group