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... :)
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 |