Re: What's the prefix? - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: What's the prefix?
Date
Msg-id CAKFQuwYc81262fkoR+A2At6a0JOcHx4x_6SMjTUgj=19LD7D3A@mail.gmail.com
Whole thread Raw
In response to What's the prefix?  ("jacktby@gmail.com" <jacktby@gmail.com>)
List pgsql-hackers
On Sun, Feb 26, 2023 at 9:16 AM jacktby@gmail.com <jacktby@gmail.com> wrote:
use these sqls:
create table t(a text);
insert into t values('a');
select lp,lp_len,t_data from heap_page_items(get_raw_page('t',0));
lp | lp_len | t_data 
----+--------+--------
  1 |     26 | \x0561
as you can see, the 61 is 'a', so what's the 05??? strange.

text is variable length so there is header information built into the datatype representation that indicates how long the content is.

David J.

pgsql-hackers by date:

Previous
From: "jacktby@gmail.com"
Date:
Subject: What's the prefix?
Next
From: Andres Freund
Date:
Subject: Re: windows/meson cfbot warnings