SQL: list all days in a month given a date within that month

sql-list-months-days.sql

PREPARE test AS
WITH RECURSIVE T(n) AS (
	SELECT date_trunc('month', $1::date)::date AS start
	UNION
	SELECT n+1 FROM T WHERE n < date_trunc('month', $1)::date + '1 month'::interval - '1 day'::interval
)
SELECT * FROM T;
EXECUTE test('15 nov 2012');