Received-SPF: pass (taragoro.hst.terra.com.br: domain of terra.com.br
	designates 200.176.10.9 as permitted sender)
	client-ip=200.176.10.9;
	envelope-from=ranieri.oliveira@terra.com.br; helo=[172.16.2.72];
Message-ID: <467697ED.8030506@terra.com.br>
Date: Mon, 18 Jun 2007 11:34:21 -0300
From: Ranieri Mazili <ranieri.oliveira@terra.com.br>
User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
MIME-Version: 1.0
To: pgsql-general@postgresql.org,  pgsql-sql@postgresql.org
Subject: Setting Variable - (Correct)
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello, I'm trying do the following function:

CREATE OR REPLACE FUNCTION lost_hours_temp(date)
RETURNS text AS
$BODY$
DECLARE
    START_DATE date;
    END_DATE date;
    QUERY text;
BEGIN
    START_DATE := $1;
    END_DATE := START_DATE - interval '3 year';
   
    WHILE EXTRACT(YEAR FROM START_DATE) = EXTRACT(YEAR FROM END_DATE)+3 LOOP
        QUERY := 'SELECT    CAST(EXTRACT(YEAR FROM A.production_date) || 
'/' || EXTRACT(MONTH FROM A.production_date) AS TEXT) as date,
                SUM(production_hours) AS production_hours,
                B.id_production_area
            FROM     production A, product B
            WHERE     EXTRACT(MONTH FROM production_date) = 
EXTRACT(MONTH FROM ' || START_DATE || ')
                AND EXTRACT(YEAR FROM A.production_date) = EXTRACT(YEAR 
FROM ' || START_DATE || ')
                AND lost_hours = ' || 'S' ||'
                AND A.id_product = B.id_product
            GROUP BY id_production_area, date';
   
        START_DATE := START_DATE - interval '1 month';
    END LOOP;

    RETURN QUERY;
END;
$BODY$
LANGUAGE 'plpgsql';

My problem is into WHILE, I'm trying to concatenate variables with the 
string, but I guess that it's generating an error.
What's the correct form to concatenate strings with query in my case?

Thanks