Size: a a a
NP
mm
SELECT set_byte('x', 0, 1) || set_byte('x', 0, 2) || set_byte('x', 0, 3);
> не обязательно bytea[5] create table test ( data bytea );YS
create table test ( data bytea );DI
create table test ( data bytea );dmitigr=> create table foo(id serial not null, dat bytea not null);
CREATE TABLE
dmitigr=> insert into foo(dat) select (1::int2::text || 2::int2::text || 3::int2::text)::bytea;
INSERT 0 1
Time: 4,144 ms
dmitigr=> select * from foo;
id | dat
----+----------
1 | \x313233
(1 row)
mm
dmitigr=> create table foo(id serial not null, dat bytea not null);
CREATE TABLE
dmitigr=> insert into foo(dat) select (1::int2::text || 2::int2::text || 3::int2::text)::bytea;
INSERT 0 1
Time: 4,144 ms
dmitigr=> select * from foo;
id | dat
----+----------
1 | \x313233
(1 row)
KZ
create table test ( data bytea );mm
KZ
VP
W
F
F
am
MM
F
A
am
MM
MM