pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Craig Ringer <craig@postnewspapers.com.au>
To: Matthew Wakeling <matthew@flymine.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Very specialised query
Date: Fri, 03 Apr 2009 00:36:02 +0800
Message-ID: <49D4E972.30608@postnewspapers.com.au> (raw)
In-Reply-To: <alpine.DEB.2.00.0904021600570.21772@aragorn.flymine.org>
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>

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




view thread (29+ messages)

Message-ID: <49D4E972.30608@postnewspapers.com.au>
Permalink:  ../49D4E972.30608@postnewspapers.com.au/
Also on:    postgresql.org/message-id/49D4E972.30608@postnewspapers.com.au

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: craig@postnewspapers.com.au, matthew@flymine.org
  Subject: Re: Very specialised query
  In-Reply-To: <49D4E972.30608@postnewspapers.com.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox