Message-ID: <20051108082511.06n26rf2fc0gk8cg@www.presserv.org>
Date: Tue, 08 Nov 2005 08:25:11 -0300
From: lucas@presserv.org
To: pgsql-sql@postgresql.org
Subject: Extract date from week
References: <20051108065256.7DFE7D7971@svr1.postgresql.org>
In-Reply-To: <20051108065256.7DFE7D7971@svr1.postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain;
	charset=ISO-8859-1;
	format="flowed"
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
User-Agent: Internet Messaging Program (IMP) H3 (4.0.3)

Hi
Looking the e-mail I remembered a question.
I saw that "select extract (week from now()::date)" will return the 
week number
of current year. But, how can I convert a week to the first reference 
date. Ex:
select extract(week from '20050105'::date);  -- 5 Jan 2005
--Returns--
date_part |
1         |

It is the first week of year (2005), and how can I get what is the first date
references the week 1? Ex:
select ???? week 1
--should return---
date     |
20050103 |     -- 3 Jan 2005

Thank you.
Lucas Vendramin