Message-ID: <4314863A.3030107@productivitymedia.com>
Date: Tue, 30 Aug 2005 12:15:54 -0400
From: Postgres Admin <postgres@productivitymedia.com>
User-Agent: Thunderbird 1.6a1 (Macintosh/20050829)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Cc: PostgreSQL - Admin <pgsql-admin@postgresql.org>
Subject: plpgsql question
References: <BAY101-DAV8EA3AA3EF2A17C6F7C9EEA3B60@phx.gbl>
	<F104769F-4833-4E10-892B-8EDCC0AE0E27@sitening.com>
	<BAY101-DAV106551B6BE74061AD63302A3AF0@phx.gbl>
	<1C7C5DE3-5EB5-4EB8-A187-290EF5081BD7@sitening.com>
In-Reply-To: <1C7C5DE3-5EB5-4EB8-A187-290EF5081BD7@sitening.com>
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 7bit

Can I do something like this:

CREATE TABLE sample (id SERIAL, node INTEGER, parent INTEGER);
INSERT INTO sample(node,parent) VALUES(1,0);
INSERT INTO sample(node,parent) VALUES(2,0);
INSERT INTO sample(node,parent) VALUES(3,1);
INSERT INTO sample(node,parent) VALUES(4,3)

CREATE OR REPLACE FUNCTION article_display(anyelement, anyelement)
RETURNS SETOF samle AS $$
    DECLARE
        articleRow sample%ROWTYPE;
    BEGIN
        FOR articleRow IN SELECT comments
        FROM theirry.articles
        ORDER BY article_id
        DESC LIMIT $1
        OFFSET $2 LOOP
    RETURN NEXT articleRow;
    END LOOP;
    RETURN;
    END;
$$ LANGUAGE plpgsql;

Thanks,
J