X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 3B0919DCA42 for ; Thu, 15 Dec 2005 14:02:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33193-06 for ; Thu, 15 Dec 2005 14:02:22 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id E86E79DCA04 for ; Thu, 15 Dec 2005 14:02:20 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jBFI2Kc3015777; Thu, 15 Dec 2005 13:02:20 -0500 (EST) To: oss-dev@rambler.ru cc: pgsql-interfaces@postgresql.org Subject: Re: Get double values from binary cursor In-reply-to: <43A16B2D.20203@rambler.ru> References: <43A16B2D.20203@rambler.ru> Comments: In-reply-to Oleg Semykin message dated "Thu, 15 Dec 2005 16:10:05 +0300" Date: Thu, 15 Dec 2005 13:02:20 -0500 Message-ID: <15776.1134669740@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.003 required=5 tests=[AWL=0.003] X-Spam-Score: 0.003 X-Spam-Level: X-Archive-Number: 200512/29 X-Sequence-Number: 5897 Oleg Semykin writes: > i want to get a double values from binary cursor > PQclear( PQexec(conn, "begin; declare my_cur binary cursor for > select 123.123;") ); This is most likely returning a numeric, not a float8. Try casting the value to float8 explicitly. regards, tom lane