Re: [GENERAL] PQgetvalue weirdness - Mailing list pgsql-general

From Chris Johnson
Subject Re: [GENERAL] PQgetvalue weirdness
Date
Msg-id Pine.LNX.4.00.9809101507450.15980-100000@boreus.bedfo.ma.tiac.net
Whole thread Raw
Responses Re: [GENERAL] PQgetvalue weirdness
List pgsql-general
I usually use pg_result... here is a snipped of some C I have used:

<<<>>>
  for (i = 0; i < PQntuples(res); i++)
    {
      dbName = PQgetvalue(res, i, 0);
<<<>>>

It works perfectly on the Linux, IRIX and Digital Unix (OSF/1)... Assuming
all the regression tests worked when you installed, and that you are
linking your program with the proper libpq, I guess the next step is to
see more of the code and to know exactly how you compiled it.

Chris

--
A language that doesn't affect the way you think about programming is
not worth knowing.

On Thu, 10 Sep 1998, Simon Drabble wrote:

>
>
> 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@syspac.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@syspac.com
>    http://fiddletrudge.dyn.ml.org/
>    KreatAPayj           --        ~simon/KreatAPayj/login.html
>    LizardCam            --        LizardCam/LizardCam.html
>    Linux Knowledge Base --        ~simon/LinuxKB/index.html
>
>


pgsql-general by date:

Previous
From: Simon Drabble
Date:
Subject: Re: [GENERAL] PQgetvalue weirdness
Next
From: Simon Drabble
Date:
Subject: Re: [GENERAL] PQgetvalue weirdness