Re: perl return codes

> I am writing a few perl scripts accessing postgres. I have used the
> examples in Bruce Momjian's book, where command results are tested.
> (Variables such as PGRES_CONNECTION_OK and PGRES_TUPLES_OK are used).
> Where can I find documentation on these types of variables, for other
> commands? (source is okay, I just cannot find it).

These are not exactly variables -- they are the calls to autoloaded
subroutines exported into your name space, so they appear to be
constants. Their values are defined in Pg.xs, in constant().

If you were asking about their meaning, I believe their names are
self-explanatory, but maybe I've just been around for too long. Look
for comments in libpq-fe.h, and if something is still unclear, be sure
to ask again.

Also, consider using DBI. It has a somewhat cleaner interface and its
error handling model is simpler, too. It's just an opinion, of
course. I once had to convert some of my code from Pg to DBI because
my users were high on portability. Nevermind that I never achieved
portablity (because many of the features I use are unique to
postgres). I but I liked it and still stick to it. I have a feeling
that it allows me to code faster and achieve greater sophistication.

--Gene