DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=j6SZVrZFAOJ0YbeltUi64OuC5g3By581ARo5CNBrlwMUPtVfDhTXIQA7tsC+otCEjp
	Ym1Z55xC6dR7ZgiU1ODqheJBqAqUyEwEBqFm7JougXMJ7CG/DWrEN2YcpaQ/ShnprUBj
	rLugDH54DHXcaNf3BLGLiN7/OURCrRf+f4lOI=
MIME-Version: 1.0
Date: Thu, 22 Oct 2009 13:31:11 -0400
Message-ID: <302670f20910221031v6cc61b5bq27accbf7d928d024@mail.gmail.com>
Subject: Assigning Values to Composite Types
From: Gary Chambers <gwchamb@gmail.com>
To: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1

All...

Given the following [hopefully] relevant portions of a function:

CREATE OR REPLACE FUNCTION solve(FLOAT8, VARCHAR, CHAR)
RETURNS SETOF sometype_t AS
$solve$
DECLARE
    data sometype_t;
...

BEGIN
    FOR term_count IN
        SELECT DISTINCT coord_type AS coord_type, MAX(term) AS maxterms
        ...
    LOOP
        FOR i IN 0 .. term_count.maxterms LOOP
            SELECT SUM(a + b + c) INTO Q
            ...
            S := S + (Q * onevalue * somevalue);
        END LOOP;
        -- This is the only means of verifying/viewing the data
        RAISE NOTICE '% = %', term_count.coord_type, S;

        /* Here is where I am stuck trying to fill data
           I've tried:

           data.term_count.coord_type := S;
           (data.term_count).coord_type := S;
           data.(term_count.coord_type) := S;
        */

        S := 0.0;
    END LOOP;
    RETURN NEXT vsop87_data;
END;
$solve$ LANGUAGE plpgsql STRICT IMMUTABLE;

Is there a means of filling something.something.something with a value
so I can get all the values into a single row?  Thanks very much in
advance.

-- Gary Chambers

/* Nothing fancy and nothing Microsoft! */