Re: DataRow message for Integer(int4) returns result as text?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Tyler Brock <tyler(dot)brock(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: DataRow message for Integer(int4) returns result as text?
Date: 2022-04-21 00:16:28
Message-ID: CAKFQuwbxCFSq6=U+35DrDQq446gXr-tWbsBpc2=P+ASaJyTUkA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Apr 20, 2022 at 5:11 PM Tyler Brock <tyler(dot)brock(at)gmail(dot)com> wrote:

> For sure, I’m thinking of it that way. Thanks for confirming.
>
> What I don’t understand is that if I respond to psql with the
> RowDescription indicating the format code is 1 for binary (and encode it
> that way, with 4 bytes, in the DataRow) it doesn’t render the number in the
> results.
>
>>
>>
Please don't top-post.

psql is a command line program, the server is PostgreSQL or postgres.

I'm not familiar with interacting with the server in C or at the protocol
level; I have no idea what that sentence is supposed to mean. But
RowDescription seems to be strictly informative so how would you "respond
to psql with [it]"?

David J.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2022-04-21 00:18:07 Re: CLUSTER sort on abbreviated expressions is broken
Previous Message Tyler Brock 2022-04-21 00:11:47 Re: DataRow message for Integer(int4) returns result as text?