pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedlibpgtcl/pg_execute undocumented feature ?
3+ messages / 3 participants
[nested] [flat]
* libpgtcl/pg_execute undocumented feature ?
@ 2002-10-04 10:16 Gerhard Hintermayer <g.hintermayer@inode.at>
0 siblings, 1 reply; 3+ messages in thread
From: g.hintermayer@inode.at @ 2002-10-04 10:16 UTC (permalink / raw)
To: pgsql-interfaces
I was just trying to implement a -numAffected option to pg_result to
get the number of affected tuples when invoking INSERT/UPDATE/DELETE
when I saw, that there is already a command that does give me the
number of affected tuples. Will pg_execute be dropped in uncoming
releases ?
Gerhard Hintermayer
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: libpgtcl/pg_execute undocumented feature ?
@ 2002-10-04 12:01 Nigel J. Andrews <nandrews@investsystems.co.uk>
parent: Gerhard Hintermayer <g.hintermayer@inode.at>
0 siblings, 1 reply; 3+ messages in thread
From: Nigel J. Andrews @ 2002-10-04 12:01 UTC (permalink / raw)
To: (Gerhard Hintermayer) <g.hintermayer@inode.at>; +Cc: pgsql-interfaces
On 4 Oct 2002, (Gerhard Hintermayer) wrote:
> I was just trying to implement a -numAffected option to pg_result to
> get the number of affected tuples when invoking INSERT/UPDATE/DELETE
> when I saw, that there is already a command that does give me the
> number of affected tuples. Will pg_execute be dropped in uncoming
> releases ?
I don't see why it would be dropped.
BTW, I've just noticed you say it's undocumented. I see it listed in
chapter 3 of the Client Interfaces, that's the 'pgtcl - Tcl Binding Library'
chapter for the 7.3 docmentation but not in my copy of the 7.2.1
documentation. So it's been documented now.
However, taking the view that there is a split between application developer
and database developer: the design of a DB can change without the application
developer knowing anything other than suddenly an INSERT command, for exmaple,
says zero tuples were affected. This generally results from the use of RULES
and may not be a problem at all and may be even less of one in 7.4. However, I
would tend to avoid building such reliance on the tuple count into an
application and unless you really do need the count I would suggest it's best
to avoid the question entirely.
--
Nigel J. Andrews
Director
---
Logictree Systems Limited
Computer Consultants
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: libpgtcl/pg_execute undocumented feature ?
@ 2002-10-04 15:58 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Nigel J. Andrews <nandrews@investsystems.co.uk>
0 siblings, 0 replies; 3+ messages in thread
From: Bruce Momjian @ 2002-10-04 15:58 UTC (permalink / raw)
To: Nigel J. Andrews <nandrews@investsystems.co.uk>; +Cc: (Gerhard Hintermayer) <g.hintermayer@inode.at>; pgsql-interfaces
Nigel J. Andrews wrote:
> On 4 Oct 2002, (Gerhard Hintermayer) wrote:
>
> > I was just trying to implement a -numAffected option to pg_result to
> > get the number of affected tuples when invoking INSERT/UPDATE/DELETE
> > when I saw, that there is already a command that does give me the
> > number of affected tuples. Will pg_execute be dropped in uncoming
> > releases ?
>
> I don't see why it would be dropped.
>
> BTW, I've just noticed you say it's undocumented. I see it listed in
> chapter 3 of the Client Interfaces, that's the 'pgtcl - Tcl Binding Library'
> chapter for the 7.3 docmentation but not in my copy of the 7.2.1
> documentation. So it's been documented now.
Yes, someone already pointed out that doc item was missing so we added
it to 7.3.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-10-04 15:58 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-10-04 10:16 libpgtcl/pg_execute undocumented feature ? Gerhard Hintermayer <g.hintermayer@inode.at>
2002-10-04 12:01 ` Nigel J. Andrews <nandrews@investsystems.co.uk>
2002-10-04 15:58 ` Bruce Momjian <pgman@candle.pha.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox