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 2841211F68C5 for ; Thu, 6 Apr 2006 09:36:31 -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 43317-02 for ; Thu, 6 Apr 2006 09:36:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from moon.antora.ru (moon.antora.ru [83.222.21.34]) by postgresql.org (Postfix) with ESMTP id 19BA611F6775 for ; Thu, 6 Apr 2006 09:36:26 -0300 (ADT) Received: from [217.26.17.26] (helo=[10.0.0.72]) by moon.antora.ru with esmtpsa (TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.60 (FreeBSD)) (envelope-from ) id 1FRTim-000Pdl-Pb; Thu, 06 Apr 2006 16:36:20 +0400 Message-ID: <44350A9B.5060109@bankir.ru> Date: Thu, 06 Apr 2006 16:33:31 +0400 From: "Eugene E." User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050517) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Stephan Szabo CC: Peter Eisentraut , Achilleus Mantzios , pgsql-sql@postgresql.org Subject: Re: have you feel anything when you read this ? References: <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> In-Reply-To: <20060406041008.M82943@megazone.bigpanda.com> 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, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200604/38 X-Sequence-Number: 24847 Stephan Szabo wrote: >>>What would you expect it to do given a single result format argument? >>> >>>If you want to propose a new function (set of functions) that have >>>different behavior, make a coherent proposal. >> >> > Statements like it should >> > do X because I want it to aren't coherent proposals. >> >>AFAIK, they convert each value before put it to a result set. >>I propose to do the following convertion to the textual-form for bytea >>values: >>X->X where X is byte [0..255] > > > Okay, now pass that to strcmp or a %s format. AFAIK, the "textual-form" of > values is meant to be a c-string. "ab\0cd\0" is not a c-string containing > ab\0cd, it's a c-string containing ab. WHY strcmp ?! do you really think the user is a fool ? if the user declared something "binary", he obviously knows what he has done. WHY c-string ? the user only wants to get PGresult structure. Since this structure provides a length of each value, you have no need in c-string. Why do think the user needs it ? "textual-form" is just a name of actually existent convertion rule. i am not trying to find out a philosophy here. > I think I don't exactly agree with this description, but I'm unclear > exactly what you're saying. Are you saying that textual-form is the > useful representation, or are you saying that textual-form is the > representation and it is useful? the actual representasion of most types is pretty useful.