supabase-postgres.git / summary / log / commit / refs

commit    10582dada8a2e1dc085f3966153753306f5517ea
Author:   Oliver Rice <github@oliverrice.com>
Commit:   GitHub <noreply@github.com>
Date:     Fri Aug 23 17:13:43 2024 +0000

    test plv8 (#1166)


 nix/tests/expected/plv8.out | 17 +++++++++++++++++
 nix/tests/sql/plv8.sql      | 14 ++++++++++++++
 2 files changed, 31 insertions(+)

diff --git a/nix/tests/expected/plv8.out b/nix/tests/expected/plv8.out
new file mode 100644
index 00000000..f24c8583
--- /dev/null
+++ b/nix/tests/expected/plv8.out
@@ -0,0 +1,17 @@
+create schema v;
+-- create a function to perform some JavaScript operations
+create function v.multiply_numbers(a integer, b integer)
+  returns integer
+  language plv8
+as $$
+  return a * b;
+$$;
+select
+  v.multiply_numbers(3, 4);
+ multiply_numbers 
+------------------
+               12
+(1 row)
+
+drop schema v cascade;
+NOTICE:  drop cascades to function v.multiply_numbers(integer,integer)
diff --git a/nix/tests/sql/plv8.sql b/nix/tests/sql/plv8.sql
new file mode 100644
index 00000000..f58360f5
--- /dev/null
+++ b/nix/tests/sql/plv8.sql
@@ -0,0 +1,14 @@
+create schema v;
+
+-- create a function to perform some JavaScript operations
+create function v.multiply_numbers(a integer, b integer)
+  returns integer
+  language plv8
+as $$
+  return a * b;
+$$;
+
+select
+  v.multiply_numbers(3, 4);
+
+drop schema v cascade;


[parent: 3e7fccd9207e]