Re: [SQL] Problem on PostgreSQL (error code, store procedures)

2002-07-10 Thread Christoph Haller
> > I would like to know if there are any global variables > storing the error code or the number of rows affected > after each execution of the SQL statement. You did not mention which interface you are using. In C there are functions available like extern const char *PQcmdTuples(PGresult *r

[SQL] Problem on PostgreSQL (error code, store procedures)

2002-07-08 Thread Carmen Wai
Hello, I would like to know if there are any global variables storing the error code or the number of rows affected after each execution of the SQL statement. Also, for Postgresql function, I have checked that I can only call the function by: select function(parms) or by EXECUTE PROCEDURE functi