out parameters ( oracle 2 pg )

From: Fred <frederic(dot)bonnard(at)cirad(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: out parameters ( oracle 2 pg )
Date: 2002-11-06 06:33:46
Message-ID: 20021106063346.GB3905@Eleogade.cirad.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am trying to convert some oracle stored procedures
to plpgsql.
One pb as many others encoutered, is that pgsql functions
do not accept out parameters, neither multiple values within
one return.
Searching the list, I found 2 interesting posts :
- one from Joshua Jore that uses "setof" but this seems not to
work with pgsql, just sql
-> http://archives.postgresql.org/pgsql-novice/2002-03/msg00046.php

- another workaround from Art Nicewick that I tried successfully,
but what about the performances ...
-> http://archives.postgresql.org/pgsql-admin/2002-03/msg00166.php

To summerize : are there any new helpful implemented functions,
enhancements in pg or better workarounds (what about Art's one ?) ?

Fred

warning : I'm a newbie in db... :)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michiel Lange 2002-11-06 07:14:35 Re: Can't connect to PGSQL
Previous Message Bruno Wolff III 2002-11-06 04:18:07 Re: Vacuum full