Received-SPF: pass (quebec.hst.terra.com.br: domain of terra.com.br designates
	200.176.10.31 as permitted sender) client-ip=200.176.10.31;
	envelope-from=ranieri.oliveira@terra.com.br; helo=[172.16.2.72];
Message-ID: <4663F114.4030903@terra.com.br>
Date: Mon, 04 Jun 2007 08:01:40 -0300
From: Ranieri Mazili <ranieri.oliveira@terra.com.br>
User-Agent: Thunderbird 2.0.0.0 (Windows/20070326)
MIME-Version: 1.0
To: pgsql-general@postgresql.org,  pgsql-sql@postgresql.org
Subject: Jumping Weekends
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello,
(sorry for my poor english)

It's my first post here, and my doubt is very simple (I guess). I have a 
function to populate a table, into "WHILE" I have the follow piece of code:

--Jump Weekend
IF (SELECT TO_CHAR(CAST(PRODUCTION_DATE as date),'Day')) = 'Saturday' THEN
           PRODUCTION_DATE := PRODUCTION_DATE + 2;
END IF;

It's to jump weekend adding 2 days on the variable "PRODUCTION_DATE", 
the type of the variable is "DATE". But, I don't know why, it's doesn't 
work properly, it's doesn't jump weekends, it's continues normally, 
someone knows what's happen or what am I doing wrong?

I appreciate any help.
Thanks

Ranieri Mazili