Re: [GENERAL] PQgetvalue weirdness

On Thu, 10 Sep 1998, Chris Johnson wrote:

> Postgres numbers the rows and fields starting at 0 - your call to get the
> first row and column would be PQgetvalue(result, 0, 0)
>
> Chris

Thanks for your reply, but..

If I have a zero for the field number (last parameter) I get a seg fault
immediately - gdb shows it to be in PQgetvalue().

If I have a row number of zero (second param) I get the same error as
below (if the column number is >0 )

Simon.

>
> On Thu, 10 Sep 1998, Simon Drabble wrote:
>
> >
> > I'm executing a (simple) query using libpq, and this is the error I get
> > from PQgetvalue(result, 1, 1):
> >
> > PQgetvalue: There is no field 1 in the query results. The highest
> > numbered field is 0.
> >
> > I get a similar error if I call getlength().
> >
> > There _is_ data there - PQprintTuples() prints everything correctly.
> >
> >
> > Can anyone shed any light? PQtrace() doesn't reveal anything useful..
> >
> >
> > Simon.
> >
> >
> > --
> > ...oooOOOooo...
> > Simon Drabble mailto:madlather(at)syspac(dot)com
> > http://fiddletrudge.dyn.ml.org/
> > KreatAPayj -- ~simon/KreatAPayj/login.html
> > LizardCam -- LizardCam/LizardCam.html
> > Linux Knowledge Base -- ~simon/LinuxKB/index.html
> >
> >
> >
>

--
...oooOOOooo...
Simon Drabble mailto:madlather(at)syspac(dot)com
http://fiddletrudge.dyn.ml.org/
KreatAPayj -- ~simon/KreatAPayj/login.html
LizardCam -- LizardCam/LizardCam.html
Linux Knowledge Base -- ~simon/LinuxKB/index.html