Is this fixed in the 7.4 release?

Поиск
Список
Период
Сортировка
От Wei Weng
Тема Is this fixed in the 7.4 release?
Дата
Msg-id 405F1DD7.7060400@kencast.com
обсуждение исходный текст
Ответы Re: Is this fixed in the 7.4 release?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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.



В списке pgsql-interfaces по дате отправления:

Предыдущее
От: "Vickriz Buenaventuura"
Дата:
Сообщение: Re: libpgtcl.so?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Is this fixed in the 7.4 release?