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

"order by" days of the week

From: "D(dot) A(dot)" <lameije(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: "order by" days of the week
Date: 2002-09-28 01:36:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

I am storing a schedule of services in a restaurant database (e.g.
breakfast, lunch...), and want to be able to order the results by the day
of the week. The table is as follows.

                Table "schedule"
   Column    |          Type          | Modifiers 
 business_id | integer                | not null
 day         | character varying(20)  | 
 start       | time without time zone | 
 finish      | time without time zone | 
 service     | character varying(30)  | 

The day collumn will hold the days of the week "Monday", "Tuesday"... etc.
When I retrieve the data, I want to be able to sort by the days in
cronological order rather than in alphabetic order. 

My questions are these:
1) Is it possible to use "order by" in conjunction with a list of strings
to tell it how to order the results?

2)Is there a way to store days of the week that is better than simply
using varchar and performing a check. I read about the time data formats
and they all seem to be more applicable to absolute times rather than
simply a day of the week. I also thought about storing the days as a
number between 1 and 7 then converting for display (1=Monday,
2=Tuesday...), but that didn't feel clean to me. 

Any suggestions?


Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!


pgsql-novice by date

Next:From: Ludwig LimDate: 2002-09-28 05:33:02
Subject: Directing the result of EXPLAIN to a file
Previous:From: Josh BerkusDate: 2002-09-27 19:05:49
Subject: PGSQL-Performance mailing list.

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