Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 37549634083
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu,  2 Apr 2009 13:36:15 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 91094-10
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu,  2 Apr 2009 13:36:12 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from www.postnewspapers.com.au (www.postnewspapers.com.au
	[202.61.230.242])
	by mail.postgresql.org (Postfix) with ESMTP id 64FCF633FC3
	for <pgsql-performance@postgresql.org>;
	Thu,  2 Apr 2009 13:36:12 -0300 (ADT)
Received: from mail.postnewspapers.com.au
	(202-89-185-120.static.dsl.amnet.net.au [202.89.185.120])
	by www.postnewspapers.com.au (Postfix) with ESMTP id 1EEEA5C146;
	Fri,  3 Apr 2009 00:36:07 +0800 (WST)
Received: from localhost (access [127.0.0.1])
	by mail.postnewspapers.com.au (Postfix) with ESMTP id 0F9BE1E0437;
	Fri,  3 Apr 2009 00:36:07 +0800 (WST)
X-Virus-Scanned: Debian amavisd-new at postnewspapers.com.au
Received: from mail.postnewspapers.com.au ([127.0.0.1])
	by localhost (access.postnewspapers.com.au [127.0.0.1]) (amavisd-new,
	port 10024)
	with LMTP id rD45tFPSCRmp; Fri,  3 Apr 2009 00:36:03 +0800 (WST)
Received: from [192.168.44.68] (203-59-94-220.perm.iinet.net.au
	[203.59.94.220])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(Client CN "Craig Ringer",
	Issuer "POST Certificate Authority" (verified OK))
	by mail.postnewspapers.com.au (Postfix) with ESMTP id 0C4A41E0436;
	Fri,  3 Apr 2009 00:36:02 +0800 (WST)
Message-ID: <49D4E972.30608@postnewspapers.com.au>
Date: Fri, 03 Apr 2009 00:36:02 +0800
From: Craig Ringer <craig@postnewspapers.com.au>
User-Agent: Thunderbird 2.0.0.21 (X11/20090319)
MIME-Version: 1.0
To: Matthew Wakeling <matthew@flymine.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Very specialised query
References: <alpine.DEB.2.00.0903261313290.21772@aragorn.flymine.org>
	<331e40660903270936u5db00807sb1169df66443ade3@mail.gmail.com>
	<alpine.DEB.2.00.0903271708080.21772@aragorn.flymine.org>
	<2298.1238179393@sss.pgh.pa.us>
	<alpine.DEB.2.00.0903301618190.21772@aragorn.flymine.org>
	<331e40660903300914x1c7747d0j94be7addeb2b31f5@mail.gmail.com>
	<alpine.DEB.2.00.0903301719230.21772@aragorn.flymine.org>
	<331e40660903301113x7371fb33n302fc3f2c720efb2@mail.gmail.com>
	<alpine.DEB.2.00.0904011811360.21772@aragorn.flymine.org>
	<alpine.DEB.2.00.0904011924150.21772@aragorn.flymine.org>
	<alpine.DEB.2.00.0904021600570.21772@aragorn.flymine.org>
In-Reply-To: <alpine.DEB.2.00.0904021600570.21772@aragorn.flymine.org>
X-Enigmail-Version: 0.95.7
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200904/42
X-Sequence-Number: 33409

Matthew Wakeling wrote:
> Trying to rewrite a plpgsql function in C.
> 
> How do I do the equivalent of:
> 
> FOR loc IN SELECT * FROM location ORDER BY objectid, intermine_start,
> intermine_end LOOP
> END LOOP;
> 
> in a C function?

Please create a new message to the list with a new subject line for a
new question.

Thanks.

--
Craig Ringer