src/test/modules/test_extensions/test_ext7--2.0--2.2bad.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

/* src/test/modules/test_extensions/test_ext7--2.0--2.2bad.sql */

-- complain if script is sourced in psql, rather than via ALTER EXTENSION
\echo Use "ALTER EXTENSION test_ext7 UPDATE TO '2.2bad'" to load this file. \quit

-- test reporting of a nested syntax error in an extension script
SET LOCAL check_function_bodies = on;

CREATE FUNCTION my_erroneous_func(int) RETURNS int LANGUAGE SQL
AS $$ SELECT $1 + , 1 $$;

CREATE FUNCTION my_other_func(int) RETURNS int LANGUAGE SQL
AS $$ SELECT $1 + 1 $$;