1/* src/test/modules/test_extensions/test_ext8--1.0.sql */ 2 3-- complain if script is sourced in psql, rather than via CREATE EXTENSION 4\echo Use "CREATE EXTENSION test_ext8" to load this file. \quit 5 6-- create some random data type 7create domain posint as int check (value > 0); 8 9-- use it in regular and temporary tables and functions 10 11create table ext8_table1 (f1 posint); 12 13create temp table ext8_temp_table1 (f1 posint); 14 15create function ext8_even (posint) returns bool as 16 'select ($1 % 2) = 0' language sql; 17 18create function pg_temp.ext8_temp_even (posint) returns bool as 19 'select ($1 % 2) = 0' language sql; 20 21-- we intentionally don't drop the temp objects before exiting 22