The description of how to return record sets can be found here (sorry, but
although I am not directly interested in returning record sets, I looked
into the manual and found this passage in five minutes):
(near the bottom, section 22.214.171.124. Returning Cursors)
However, if that does not help, I can't provide further assistance.
By the way - what is the difference between "functions" and "procedures" ?
In my understanding, the PL/pgSQL functions ARE what is in other DBMSes
called stored procedures, although they are not called so. If this is not
the case, I would be interested in the difference of PL/pgSQL functions and
"real" stored procedures. Of course I don't mean differences in the
procedural language, because these languages are not standardized anywhay.
Best regards, Remigius.
----- Original Message -----
From: "Peter Adamek Jr." <peter(dot)adamek(at)utoronto(dot)ca>
To: <pgsql-jdbc(at)postgresql(dot)org>; <pgsql-general(at)postgresql(dot)org>
Sent: Sunday, December 22, 2002 8:14 PM
Subject: [JDBC] Stored procedures/functions that can return recordsets...
> Hello all,
> This email is in regards to the following statement that I found just
> last week:
> "PostgreSQL 7.3 is full of new, often requested features such as SQL '92
> schemas, prepared statements, and stored procedures that can return
> record sets."
> The statement is part of a larger article and can be found about half
> way down the following article:
> I am specifically interested in the portion of the statement that reads
> "stored procedures that can return record sets." If this is indeed
> true, then I believe that PostgreSQL will become a much more used DB.
> This is one aspect that MS SQL Server and Oracle have had for some time
> that has been lacking from PostgreSQL (not to mention the Callable
> Statement JDBC driver support that is now included in version 7.3).
> I am writing this to see if anyone has been able to successfully run a
> stored procedure (although it is probably still called a function) via
> Java (using a Callable Statement) and have it return a recordset (that
> is multiple columns and multiple rows). If so, I would appreciate it if
> you could post a short example, both of the stored procedure and the
> Java code used to access it.
> I have looked through the 7.3 documentation at the following link, but I
> have not found any references to this functionality.
> I suspect that even in PostgreSQL version 7.3 no such thing as stored
> procedures exist - I suspect it was a misquote and the article is
> referring to functions.
> In any event, I'd like to see this run for my own interest, it's not for
> a project. I know what needs to be done in theory, so I'll tinker with
> it to try and get it to work on my own. If anyone has any suggestions
> or has got this to work and would like to shed light on this, I would
> appreciate it.
> Thank you kindly,
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
In response to
pgsql-jdbc by date
|Next:||From: Barry Lind||Date: 2002-12-23 17:42:21|
|Subject: Re: JDBC warning on setAutoCommit(false)|
|Previous:||From: Florian Wunderlich||Date: 2002-12-23 13:05:08|
|Subject: toTimestamp fractional seconds fix (patch against CVS)|
pgsql-general by date
|Next:||From: Lamar Owen||Date: 2002-12-23 17:13:04|
|Subject: Re: 7.3 RPM's for SuSE?|
|Previous:||From: Çağıl Şeker||Date: 2002-12-23 16:44:50|
|Subject: SQL Injection & Stored Procedures Info|