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

2022-04-20 Thread Tyler Brock
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 wrote: > On Wed, Apr 20, 2022 at 5:11 PM Tyler Brock wrote: > >> For sure, I’m thinking of it that way. Thanks for confirming

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

2022-04-20 Thread Tyler Brock
Apr 20, 2022 at 8:00:18 PM, David G. Johnston wrote: > On Wed, Apr 20, 2022 at 4:39 PM Tyler Brock wrote: > >> I think this makes sense but I wanted to get confirmation: >> >> I created a table with a column having the type int4 (integer). When I >> insert a row with

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

2022-04-20 Thread Tyler Brock
I think this makes sense but I wanted to get confirmation: I created a table with a column having the type int4 (integer). When I insert a row with a number into that column and get it back out I've observed a discrepancy: The DataRow message has the field encoded as an ASCII ‘7’ with a column le

Re: Are OIDs for pg_types constant?

2022-04-20 Thread Tyler Brock
Thank you Tom, this is exactly what I was looking for. -Tyler On Apr 20, 2022 at 11:23:59 AM, Tom Lane wrote: > Tyler Brock writes: > > I am writing a program that behaves like a Postgres backend and can see > > that if I select oid from pg_type that the type old’s could

Are OIDs for pg_types constant?

2022-04-20 Thread Tyler Brock
Hi everyone, I am writing a program that behaves like a Postgres backend and can see that if I select oid from pg_type that the type old’s could be returned in the Row Description message for the field’s data type and that seems to work. However, I didn’t read anywhere that these are guaranteed t