Stored Procedure FAQ

From: "Joe Shevland" <J_Shevland(at)TurnAround(dot)com(dot)au>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Stored Procedure FAQ
Date: 1999-03-11 04:56:34
Message-ID: 002601be6b7b$898d97a0$6e01a8c0@tasshev.turnaround.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi (asbestos suit donned),

I've attempted to swim through the mail archives on this one, and my
question has been asked but I couldn't locate an answer. The doco is a bit
lightweight on functions/stored procs too.

So: how can I implement a stored procudure/function that returns a
resultset? I saw the one using the 'setof' operator which I'd never seen
before, and that was returning integer values and I don't think the guy got
a response. I saw another one with no response too.

Cheers and TIA,
Joe.

--
Joe Shevland
Turnaround Solutions Pty. Ltd.
mailto:J_Shevland(at)Turnaround(dot)com(dot)au
http://www.TurnAround.com.au
Ph: +61-03-6224-9146
Fax: +61-03-6223-2556

Browse pgsql-sql by date

  From Date Subject
Next Message Vikrant Rathore 1999-03-11 05:59:03 unsubscribe
Previous Message secret 1999-03-10 21:59:48 Re: [SQL] Re: How to optimize a query... -- Extreme performance difference, same EXPLAIN