X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id C432511F691F
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  6 Apr 2006 09:33:22 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 40859-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  6 Apr 2006 09:33:16 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210])
	by postgresql.org (Postfix) with ESMTP id 497BE11F68C5
	for <pgsql-sql@postgresql.org>; Thu,  6 Apr 2006 09:33:20 -0300 (ADT)
Received: by megazone.bigpanda.com (Postfix, from userid 1001)
	id 2D4AD3509F; Thu,  6 Apr 2006 05:33:20 -0700 (PDT)
Received: from localhost (localhost [127.0.0.1])
	by megazone.bigpanda.com (Postfix) with ESMTP
	id 2B7AA3509A; Thu,  6 Apr 2006 05:33:20 -0700 (PDT)
Date: Thu, 6 Apr 2006 05:33:20 -0700 (PDT)
From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: "Eugene E." <sad@bankir.ru>
Cc: pgsql-sql@postgresql.org
Subject: Re: have you feel anything when you read this ?
In-Reply-To: <20060406041008.M82943@megazone.bigpanda.com>
Message-ID: <20060406052747.Q93517@megazone.bigpanda.com>
References: <Pine.LNX.4.44.0603201522410.22894-100000@matrix.gatewaynet.com>
	<441EA0A7.8030601@bankir.ru> <200603201415.30719.peter_e@gmx.net>
	<442CC95C.1030700@bankir.ru>
	<20060331084503.W64402@megazone.bigpanda.com>
	<44324AB6.2060104@bankir.ru>
	<20060404071118.C19036@megazone.bigpanda.com>
	<4433650E.1020508@bankir.ru>
	<20060405071322.Y58168@megazone.bigpanda.com>
	<4434A207.6010600@bankir.ru>
	<20060405224337.Y83930@megazone.bigpanda.com>
	<4434C0A9.6000001@bankir.ru>
	<20060406041008.M82943@megazone.bigpanda.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120]
X-Spam-Score: 0.12
X-Spam-Level: 
X-Archive-Number: 200604/37
X-Sequence-Number: 24846


On Thu, 6 Apr 2006, Stephan Szabo wrote:

> On Thu, 6 Apr 2006, Eugene E. wrote:
>
> If you meant that you must retrieve them in a separate query, you're
> incorrect, since you *could* use the binary form for the others. I can't
> understand if you don't realize that there is one for all these various
> types, or that you just don't wish to use it (for example, I believe using
> %d on ntohl(value from pqgetvalue) or something similar will print your
> integer).

For notes sake, the example code with binary retrieval in the docs seems
to have
 ntohl(*((uint32_t *) iptr))
for iptr being the result of PQgetvalue on an integer column.