SELECT
COUNT
(
*
)
AS
total_days
FROM
(
SELECT
DATE
'2008-8-26'
+
generate_series
(
0
,
(
DATE
'2008-9-1'
-
DATE
'2008-8-26'
)
)
AS
all_days
)
AS
calendar
WHERE
EXTRACT
(
isodow
FROM
all_days
)
<
6
;
-- based on http://pastebin.com/m4c143e84