diff options
Diffstat (limited to 'src/test/regress/sql/aggregates.sql')
-rw-r--r-- | src/test/regress/sql/aggregates.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/src/test/regress/sql/aggregates.sql b/src/test/regress/sql/aggregates.sql index 04ec67b33af..01c2e2d3caf 100644 --- a/src/test/regress/sql/aggregates.sql +++ b/src/test/regress/sql/aggregates.sql @@ -416,3 +416,18 @@ select string_agg(distinct f1, ',' order by f1) from varchar_tbl; -- ok select string_agg(distinct f1::text, ',' order by f1) from varchar_tbl; -- not ok select string_agg(distinct f1, ',' order by f1::text) from varchar_tbl; -- not ok select string_agg(distinct f1::text, ',' order by f1::text) from varchar_tbl; -- ok + +-- bytea_agg tests +create table bytea_test_table(v bytea); + +select bytea_agg(v) from bytea_test_table; + +insert into bytea_test_table values(decode('ff','hex')); + +select bytea_agg(v) from bytea_test_table; + +insert into bytea_test_table values(decode('aa','hex')); + +select bytea_agg(v) from bytea_test_table; + +drop table bytea_test_table; |