Date: Mon, 15 Sep 2003 09:11:25 +0200
To: pgsql-interfaces@postgresql.org
Subject: ColumnName and ColumnNumber in libpq (C interface)
Message-ID: <20030915071125.GA7389@guadiana.unex.es>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
User-Agent: Mutt/1.3.28i
From: Alberto Cabello Sanchez <alberto@unex.es>

I think this behaviour is not fine:
I create a table with
CREATE TABLE foo ("Bar" VARCHAR(1));

I thougth running this helloworldish C program:

#include <stdio.h>
#include <libpq-fe.h>
 
int main(int argc,char **argv)
{
        PGconn * conn = PQconnectdb("dbname=pruebas");
        PGresult * res = PQexec(conn,"SELECT * from foo");
        printf("%s\n",PQfname(res,0));
        printf("%d\n",PQfnumber(res,"Bar"));
        PQfinish(conn);
}

should print 

Bar
0

but stdout shows

Bar
-1

What is happening? Any ideas? Is this a bug, a feature or something I'm missing?

-- 
-----------------------
Alberto Cabello Sánchez
alberto@unex.es
Servicio de Informática
924 289 351
-----------------------