sqlc-dev
diff --git a/‎internal/endtoend/testdata/json_build/postgresql/pgx/go/query.sql.go
Lines changed: 60 additions & 0 deletions b/‎internal/endtoend/testdata/json_build/postgresql/pgx/go/query.sql.go
Lines changed: 60 additions & 0 deletions
diff --git a/‎internal/endtoend/testdata/json_build/postgresql/pgx/query.sql
Lines changed: 16 additions & 0 deletions b/‎internal/endtoend/testdata/json_build/postgresql/pgx/query.sql
Lines changed: 16 additions & 0 deletions
diff --git a/‎internal/endtoend/testdata/json_build/postgresql/stdlib/go/query.sql.go
Lines changed: 60 additions & 0 deletions b/‎internal/endtoend/testdata/json_build/postgresql/stdlib/go/query.sql.go
Lines changed: 60 additions & 0 deletions
diff --git a/‎internal/endtoend/testdata/json_build/postgresql/stdlib/query.sql
Lines changed: 16 additions & 0 deletions b/‎internal/endtoend/testdata/json_build/postgresql/stdlib/query.sql
Lines changed: 16 additions & 0 deletions
diff --git a/‎internal/engine/postgresql/pg_catalog.go
Lines changed: 14 additions & 4 deletions b/‎internal/engine/postgresql/pg_catalog.go
Lines changed: 14 additions & 4 deletions
@@ -13,3 +13,19 @@ SELECT
   json_build_array(1, 2),
   json_build_array(1, 2, 'foo'),
   json_build_array(1, 2, 'foo', 4);
+
+-- name: SelectJSONBBuildObject :one
+SELECT
+  jsonb_build_object(),
+  jsonb_build_object('foo'),
+  jsonb_build_object('foo', 1),
+  jsonb_build_object('foo', 1, 2),
+  jsonb_build_object('foo', 1, 2, 'bar');
+
+-- name: SelectJSONBBuildArray :one
+SELECT 
+  jsonb_build_array(),
+  jsonb_build_array(1),
+  jsonb_build_array(1, 2),
+  jsonb_build_array(1, 2, 'foo'),
+  jsonb_build_array(1, 2, 'foo', 4);
@@ -13,3 +13,19 @@ SELECT
   json_build_array(1, 2),
   json_build_array(1, 2, 'foo'),
   json_build_array(1, 2, 'foo', 4);
+
+-- name: SelectJSONBBuildObject :one
+SELECT
+  jsonb_build_object(),
+  jsonb_build_object('foo'),
+  jsonb_build_object('foo', 1),
+  jsonb_build_object('foo', 1, 2),
+  jsonb_build_object('foo', 1, 2, 'bar');
+
+-- name: SelectJSONBBuildArray :one
+SELECT 
+  jsonb_build_array(),
+  jsonb_build_array(1),
+  jsonb_build_array(1, 2),
+  jsonb_build_array(1, 2, 'foo'),
+  jsonb_build_array(1, 2, 'foo', 4);