summaryrefslogtreecommitdiffstats
path: root/src/test/modules/plsample/sql/plsample.sql
blob: bf0fddac7fc8ee5f9377a5692fe9992caec47525 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
CREATE EXTENSION plsample;
-- Create and test some dummy functions
CREATE FUNCTION plsample_result_text(a1 numeric, a2 text, a3 integer[])
RETURNS TEXT
AS $$
  Example of source with text result.
$$ LANGUAGE plsample;
SELECT plsample_result_text(1.23, 'abc', '{4, 5, 6}');

CREATE FUNCTION plsample_result_void(a1 text[])
RETURNS VOID
AS $$
  Example of source with void result.
$$ LANGUAGE plsample;
SELECT plsample_result_void('{foo, bar, hoge}');