X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A144553819 for ; Wed, 30 Mar 2005 18:13:18 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63460-05 for ; Wed, 30 Mar 2005 17:13:15 +0000 (GMT) Received: from mail.innovision.com (64-126-22-242.biztype2.everestkc.net [64.126.22.242]) by svr1.postgresql.org (Postfix) with ESMTP id A5E86537DF for ; Wed, 30 Mar 2005 18:13:13 +0100 (BST) Message-ID: <424ADDC0.8070603@innovision.com> Date: Wed, 30 Mar 2005 11:11:28 -0600 From: Marvin Bellamy User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: libpq: Newbie help w/ data type conversions on queries and updates Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/84 X-Sequence-Number: 5413 I'm coming from a Java background, so I'm relatively new to C/C++ in general. I want to convert the data retrieved from a field to an "external" data type I can use; specifically a datetime or a timestamp. It looks like the only option for retrieving field data is as raw bytes, but I haven't found any information on mapping those byte streams to structures. Also, is there any sort of a libpq API, or are you just stuck with perusing header files? I had zero luck following the build instructions for libpqxx on Windows, so it looks like libpq is my only option for now. -- Marvin Keith Bellamy Software Engineer Innovision Corporation 913.438.3200