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: 28071.1109284368@sss.pgh.pa.us (view raw or flat)
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

Responses

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-2014 The PostgreSQL Global Development Group