Обсуждение: Segementation fault in PQgetvalue()

This is what I'm trying to:

char lmt_str[100];
sprintf(lmt_str,"%s",PQgetvalue(res, 0, nFields-1));
//the last field is of type timestamp


This is giving segmentation fault.
I'm confused....

Nikhil Bokare <nbokare@gmail.com> writes:
> This is what I'm trying to:
> char lmt_str[100];
> sprintf(lmt_str,"%s",PQgetvalue(res, 0, nFields-1));
> //the last field is of type timestamp
> This is giving segmentation fault.
> I'm confused....

The only way PQgetvalue will return NULL is if the row/column numbers
are out of range.  Are you sure you calculated the field number
correctly?  Are you sure the query result contains a row at all?
(Did you check for query failure?)

            regards, tom lane