Message-ID: <405F1DD7.7060400@kencast.com>
Date: Mon, 22 Mar 2004 12:09:43 -0500
From: Wei Weng <wweng@kencast.com>
User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207)
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Is this fixed in the 7.4 release?
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I am having troubles the following code on PostgreSQL 7.3.1.

[snip]
    res = PQexec(conn, "SELECT '' AS blah");
    if (!res)
    {
        fprintf(stderr, "SELECT command failed: %s\n", 
PQerrorMessage(conn));
        PQclear(res);
        exit_nicely(conn);
    }

    fprintf(stdout, "OID(%d)\n", PQftype(res, 0));
   
    PQclear(res);
[/snip]

Basically, I am asking the program to return me the field type of the 
first column in the command "select '' AS blah". I was expecting 
something like a CHAROID, but the return value is UNKNOWNOID (OID(705)). 
D'oh. And I also tried "select ' ' AS blah", as well as "select 'A' AS 
blah", they all returned me UNKNOWNOID (OID(705)) for the first column.

Is this a bug? If it is, is it fixed in 7.4 release possibly?


-- 
Wei Weng
KenCast Inc.