I just found this one on my TODO list:

The error message for "no data" in an exec sql insert select from statement
has to be 100.

It seems I cannot get that kind of information from libpq other than
checking for the result being 0 tuples. But is this correct? Or are there
possibilities to get 0 tuples? That is I get PQcmdTuples(results) = 0 with
the return code being PGRES_COMMAND_OK.

Also I wonder if PGRES_COMMAND_OK could come from other statements for which
setting the not found marker makes no sense. I think it does make sense for
insert, delete and update.

On the other hand returning NOT_FOUND on other commands doesn't do hany harm
though since the whenever not found isn't checked for other commands.

Michael
-- 
Dr. Michael Meskes		meskes@online-club.de, meskes@debian.org
Go SF49ers! Go Rhein Fire!	Use Debian GNU/Linux! 

Fri, 14 Aug 1998 10:49:01 +0200
"Dr. Michael Meskes" <meskes@online-club.de>
ecpg problem
On Fri, 14 Aug 1998, Dr. Michael Meskes wrote:

> I just found this one on my TODO list:
> 
> The error message for "no data" in an exec sql insert select from statement
> has to be 100.
> 
> It seems I cannot get that kind of information from libpq other than
> checking for the result being 0 tuples. But is this correct? Or are there
> possibilities to get 0 tuples? That is I get PQcmdTuples(results) = 0 with
> the return code being PGRES_COMMAND_OK.

Shouldn't you check for PGRES_TUPLES_OK ? I always check for this if I 
want to know if a data select statement has succeeded. And this also 
still allows PQntuples() == 0

Maarten

_____________________________________________________________________________
| TU Delft, The Netherlands, Faculty of Information Technology and Systems  |
|                   Department of Electrical Engineering                    |
|           Computer Architecture and Digital Technique section             |
|                          M.Boekhold@et.tudelft.nl                         |
-----------------------------------------------------------------------------


Sat, 15 Aug 1998 12:27:55 +0200 (MET DST)
Maarten Boekhold <maartenb@dutepp0.et.tudelft.nl>
Re: [HACKERS] ecpg problem
On Sat, Aug 15, 1998 at 12:27:55PM +0200, Maarten Boekhold wrote:
> > It seems I cannot get that kind of information from libpq other than
> > checking for the result being 0 tuples. But is this correct? Or are there
> > possibilities to get 0 tuples? That is I get PQcmdTuples(results) = 0 with
> > the return code being PGRES_COMMAND_OK.
> 
> Shouldn't you check for PGRES_TUPLES_OK ? I always check for this if I 

No, the insert command doesn't return any tuples anyway. But then I don't
check for it either. libecpg has to work with every return value and so
checks them all. It just happens that the insert commend returns
PGRES_COMMAND_OK. :-)

Michael

-- 
Dr. Michael Meskes		meskes@online-club.de, meskes@debian.org
Go SF49ers! Go Rhein Fire!	Use Debian GNU/Linux! 

Sun, 16 Aug 1998 13:59:37 +0200
"Dr. Michael Meskes" <meskes@online-club.de>
Re: [HACKERS] ecpg problem