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
begin:vcard fn:Joshua D. Drake n:Drake;Joshua D. org:Command Prompt, Inc. adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA email;internet:[EMAIL PROTECTED] title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl. x-mozilla-html:FALSE url:http://www.commandprompt.com/ version:2.1 end:vcard
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
