mstory@xxxxxxxxxxxx writes: > I need to know the day of the week for a schedule rotation algorithm > i'm working on. extract(dow ...) might help. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match