| From: | Chris Johnson <cmj(at)inline-design(dot)com> |
|---|---|
| To: | Simon Drabble <madlather(at)syspac(dot)com> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] PQgetvalue weirdness |
| Date: | 1998-09-10 18:19:48 |
| Message-ID: | Pine.LNX.4.00.9809101418550.15980-100000@boreus.bedfo.ma.tiac.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
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
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Drabble | 1998-09-10 18:42:59 | Re: [GENERAL] PQgetvalue weirdness |
| Previous Message | Przemyslaw Bak | 1998-09-10 17:47:56 | 1.2e+02 -> 120 |