From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from concorde.inria.fr (concorde.inria.fr [192.93.2.39]) by yquem.inria.fr (Postfix) with ESMTP id 0B4D2BBCC for ; Tue, 24 Jan 2006 19:28:47 +0100 (CET) Received: from pauillac.inria.fr (pauillac.inria.fr [128.93.11.35]) by concorde.inria.fr (8.13.0/8.13.0) with ESMTP id k0OISk23018172 for ; Tue, 24 Jan 2006 19:28:46 +0100 Received: from concorde.inria.fr (concorde.inria.fr [192.93.2.39]) by pauillac.inria.fr (8.7.6/8.7.3) with ESMTP id TAA14561 for ; Tue, 24 Jan 2006 19:28:45 +0100 (MET) Received: from smtp107.biz.mail.mud.yahoo.com (smtp107.biz.mail.mud.yahoo.com [68.142.200.255]) by concorde.inria.fr (8.13.0/8.13.0) with SMTP id k0OISiwt018168 for ; Tue, 24 Jan 2006 19:28:45 +0100 Received: (qmail 83163 invoked from network); 24 Jan 2006 18:28:44 -0000 Received: from unknown (HELO ?192.168.0.4?) (sullivan@mayachitra.com@66.14.187.7 with plain) by smtp107.biz.mail.mud.yahoo.com with SMTP; 24 Jan 2006 18:28:43 -0000 Mime-Version: 1.0 (Apple Message framework v746.2) Content-Transfer-Encoding: 7bit Message-Id: Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed To: caml-list@inria.fr From: Kenneth Sullivan Subject: binary data from Postgresql with cursors Date: Tue, 24 Jan 2006 10:28:42 -0800 X-Mailer: Apple Mail (2.746.2) X-Miltered: at concorde with ID 43D671DE.001 by Joe's j-chkmail (http://j-chkmail.ensmp.fr)! X-Miltered: at concorde with ID 43D671DC.000 by Joe's j-chkmail (http://j-chkmail.ensmp.fr)! X-Spam: no; 0.00; binary:01 binary:01 kenneth:98 ints:01 data:02 data:02 tuple:02 floats:02 string:02 types:02 module:03 module:03 converted:04 usual:05 i'm:08 X-Spam-Checker-Version: SpamAssassin 3.0.3 (2005-04-27) on yquem.inria.fr X-Spam-Level: X-Spam-Status: No, score=0.0 required=5.0 tests=none autolearn=disabled version=3.0.3 Hi, I'm trying to pull binary data out of a postgresql database with the Postgresql module. In postgresql, CURSORs have a binary option, which skips the usual conversion to text (which must be converted back). However the module methods for getting data from a result, e.g. get_tuple, getvalue, all return string types, with no straightforward way to get ints and floats. Has anyone else ran into this? Thanks, Ken Sullivan