Re: [GENERAL] Possible move away from PG

2005-06-30 Thread Jason Tesser
blo Baena [mailto:[EMAIL PROTECTED] Sent: Thursday, June 30, 2005 12:30 PM To: Jason Tesser Cc: Pgsql Subject: Re: [GENERAL] Possible move away from PG   If found this article of help: http://www.onjava.com/pub/a/onjava/2003/08/13/stored_procedures.html?page=2 On 6/30/05, Jason Tesser <

Re: [GENERAL] Possible move away from PG

2005-06-30 Thread Bob
PL/SQL is awesome just awesome no doubt about it.   But if you like to pay at a minium for 5 users 800 bucks then stick with PL/SQL.  I personally can live with pl/psql and at a higher level postgresql to be honest.  Not to mention the rate that things are being added and improved is mind numbing.

Re: [GENERAL] Possible move away from PG

2005-06-30 Thread Pablo Baena
If found this article of help: http://www.onjava.com/pub/a/onjava/2003/08/13/stored_procedures.html?page=2 On 6/30/05, Jason Tesser <[EMAIL PROTECTED]> wrote: I am not familar with how to do this.  Could you give me an example of howthis could help?>> Have you considered returing refcursors instead

Re: [GENERAL] Possible move away from PG

2005-06-30 Thread Jason Tesser
I am not familar with how to do this. Could you give me an example of how this could help? > > Have you considered returing refcursors instead of setof some type. > > Kris Jurka -- Jason Tesser Developer for NMI [EMAIL PROTECTED] Eph 2:8-10 ---(end of broadcast)--

Re: [GENERAL] Possible move away from PG

2005-06-30 Thread Kris Jurka
On Thu, 30 Jun 2005, Jason Tesser wrote: > 1. Our dev plan involves alot of stored procedures to be used and we > have found the way this is done in PG to be painful. (ie. To return > multiple record from different tables you have to define a type. This > is a pain to maintain because if you e