Re: [HACKERS] ecpg problem
Maarten Boekhold <maartenb@dutepp0.et.tudelft.nl>
From: Maarten Boekhold <maartenb@dutepp0.et.tudelft.nl>
To: "Dr. Michael Meskes" <meskes@online-club.de>
Cc: PostgreSQL Hacker <pgsql-hackers@postgreSQL.org>
Date: 1998-08-15T10:27:55Z
Lists: pgsql-hackers
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 | -----------------------------------------------------------------------------