use cursor in a function

From: Rory Campbell-Lange <rory(at)campbell-lange(dot)net>
To: Postgresql Novice List <pgsql-novice(at)postgresql(dot)org>
Subject: use cursor in a function
Date: 2003-06-17 10:18:43
Message-ID: 20030617101843.GB6763@campbell-lange.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

This is a repost of a question which still confuses me.

I wish to write a function that returns NUM_ROWS for a particular
condition AND a subset of those rows (eg by using LIMIT and OFFSET).

I imagine having function b that returns a reference to a cursor and
NUMROWS. In function a I use the cursor to effectively do the LIMIT and
OFFSET, and append the NUM_ROWS column to all of the results.

Is this sensible, efficient, feasible? I have not used cursors before.

Or should I simply do 2 separate functions, 1 for NUM_ROWS, the
other for the result set I want?

Help much appreciated!
Rory
--
Rory Campbell-Lange
<rory(at)campbell-lange(dot)net>
<www.campbell-lange.net>

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Joe Conway 2003-06-17 10:26:02 Re: use cursor in a function
Previous Message HK 2003-06-17 09:33:50 Notify postmaster crash??