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

From: Tyler Brock <tyler(dot)brock(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(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:21:41
Message-ID: CACr_h8T43HHrFeofuis65WngtXLZKcrPUWA1=ED-PY31sG+1-A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I’m not sure what top-posting is?

I’m talking about responding to psql the command line program.

-Tyler

On Apr 20, 2022 at 8:16:28 PM, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

> 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 David G. Johnston 2022-04-21 00:26:26 Re: DataRow message for Integer(int4) returns result as text?
Previous Message Peter Geoghegan 2022-04-21 00:18:07 Re: CLUSTER sort on abbreviated expressions is broken