Re: type unknown - how important is it?

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: type unknown - how important is it?
Дата
Msg-id 4159C23A.2030604@commandprompt.com
обсуждение исходный текст
Ответ на type unknown - how important is it?  (Shachar Shemesh <psql@shemesh.biz>)
Ответы Re: type unknown - how important is it?  (Shachar Shemesh <psql@shemesh.biz>)
Список pgsql-hackers
Shachar Shemesh wrote:
> I have a complaint from an OLE DB user that when he does "select 'a'",
> he gets an "unhanded type" error. Since OLE DB uses a binary interface,
> it has to know about all variable types that pass through it.
>
> The debug information for the problem show that the returned type is
> 705, which is "unknown". My question is - what is "unknown" used for? Is
> it important to support binary send and receives with this type? Does
> postgresql know how to convert it to other types?
>
> I was under the impression that 'a' would be "text". Why is "unknown"
> used instead?

Try casting a to varchar. Which is binary compatible but understood by
ODBC/OLE DB.

Sincerely,

Joshua D. Drake



>
>             Shachar
>


Вложения

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

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: shared memory release following failed lock acquirement.
Следующее
От: Shachar Shemesh
Дата:
Сообщение: Re: type unknown - how important is it?