Skip site navigation (1) Skip section navigation (2)

Re: [JDBC] Where are we on stored procedures?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Francisco Figueiredo Jr(dot)" <fxjrlists(at)yahoo(dot)com(dot)br>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Where are we on stored procedures?
Date: 2005-02-24 22:32:48
Message-ID: (view raw or whole thread)
Lists: pgsql-hackerspgsql-jdbc
"Francisco Figueiredo Jr." <fxjrlists(at)yahoo(dot)com(dot)br> writes:
> Could I add another item?

> Could we have the row count of statements executed inside a
> procedure/function returned to client?

IMHO that request is completely bogus; if the procedure wants to tell
the client that, it's the procedure's responsibility to return the
number as a result.  Doing what you ask (a) would arguably be a security
violation, and (b) the info would be impossible for the client to
interpret in any but the most trivial cases anyway.  Consider for
instance a procedure that contains different queries in the THEN and
the ELSE arms of an IF, or contains loops executed a variable number
of times.  Without access to the results of the control flow tests, the
client could not know which number means what.

			regards, tom lane

In response to


pgsql-hackers by date

Next:From: Marc G. FournierDate: 2005-02-24 22:38:12
Subject: Re: Some download statistics
Previous:From: Bruce MomjianDate: 2005-02-24 22:28:44
Subject: Re: [PATCHES] [pgsql-hackers-win32] Repleacement for src/port/snprintf.c

pgsql-jdbc by date

Next:From: Gavin SherryDate: 2005-02-24 23:23:31
Subject: Re: Where are we on stored procedures?
Previous:From: Francisco Figueiredo Jr.Date: 2005-02-24 21:49:35
Subject: Re: [JDBC] Where are we on stored procedures?

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group