Is this fixed in the 7.4 release?

From: Wei Weng <wweng(at)kencast(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Is this fixed in the 7.4 release?
Date: 2004-03-22 17:09:43
Message-ID: 405F1DD7.7060400@kencast.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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.

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2004-03-22 17:44:41 Re: Is this fixed in the 7.4 release?
Previous Message B Feilmeier 2004-03-22 13:37:27 PostgreSQL-Perl Interface installation