Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B94689FB24E for ; Sun, 4 Mar 2007 11:23:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 16663-04 for ; Sun, 4 Mar 2007 11:23:06 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web36709.mail.mud.yahoo.com (web36709.mail.mud.yahoo.com [209.191.85.43]) by postgresql.org (Postfix) with SMTP id 789B49FB208 for ; Sun, 4 Mar 2007 11:23:12 -0400 (AST) Received: (qmail 95207 invoked by uid 60001); 4 Mar 2007 15:23:10 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=XeDA9gPXkfxHZbOKQfP4ZuAMM4mRGHbD0YU4cW4Ec7GCRnTpIZ3pcIeROZei4YZ8bb52GshPWhbP8HWUslT1nW/mYGdSS/FsAcOb72CRvphSa5eMrUqx8x+GV6b/ReaocdGh1cCF/ZWT9gvei/dehaOoamQQ9yqC7cMXZ7BOJQM= ; Message-ID: <20070304152310.95205.qmail@web36709.mail.mud.yahoo.com> X-YMail-OSG: 9Y6dbVEVM1nti57qLdcT.ddTh65pzqghufVBV.0.QGKAtUg4BeRBbVuDOtInVbiGBqATpETvBvCG4FYOHDMOf6e8vkO_imjOY_rruqPykfOLN626WjBeAQiFSeUxAgg82Zb3J6hEk4nDn5937GQ1ckpvbg-- Received: from [58.69.19.185] by web36709.mail.mud.yahoo.com via HTTP; Sun, 04 Mar 2007 07:23:10 PST Date: Sun, 4 Mar 2007 07:23:10 -0800 (PST) From: "::Willi the One::" Subject: Retrieving timestamp data To: pgsql-interfaces@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.647 tagged_above=0 required=5 tests=BAYES_50, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, FROM_HAS_ULINE_NUMS X-Spam-Level: *** X-Archive-Number: 200703/8 X-Sequence-Number: 6449 In the documentation, it says that PQgetvalue() returns string values for strings and "the value is in the binary representation determined by the data type’s typsend and typreceive functions." The problem is, where's the typsend and typrecieve located? I know that it's not in libpq, but I saw libpgtypes somewhere in the postgres directory and saw that there are PGTYPE-related functions but I can't find the typsend. For example, if I want to retrieve a timestamp data, how would I do it? Will it return as a string when I call PQgetvalue()? What about other types such Points or inet types? Thanks in advance. Life is too short for dial-up. ____________________________________________________________________________________ Now that's room service! Choose from over 150,000 hotels in 45,000 destinations on Yahoo! Travel to find your fit. http://farechase.yahoo.com/promo-generic-14795097