summaryrefslogtreecommitdiff
path: root/db/rest/util/_api_raise_unique.sql
blob: a18d9602e9284e6dab1e74ebac717d8e0a57bfd0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
CREATE FUNCTION _api.raise_unique(
	_column TEXT DEFAULT ''
)
RETURNS BOOLEAN
LANGUAGE plpgsql VOLATILE
AS $BODY$
BEGIN
	PERFORM _api.raise(
		_msg => 'api_unique_value',
		_detail => _column
	);

	RETURN TRUE;
END
$BODY$;

GRANT EXECUTE ON FUNCTION _api.raise_unique(TEXT)
	TO rest_anon, rest_user;