]> git.evergreen-ils.org Git - working/Evergreen.git/blob - Open-ILS/src/sql/Pg/upgrade/XXXX.function.non-set-returning-evergreen.org_top.sql
Lp 1730726: Basic Patch to build the database with PostgreSQL 10.
[working/Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / XXXX.function.non-set-returning-evergreen.org_top.sql
1 BEGIN;
2
3 -- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
4
5 CREATE OR REPLACE FUNCTION evergreen.org_top()
6 RETURNS actor.org_unit AS $$
7     SELECT * FROM actor.org_unit WHERE parent_ou IS NULL LIMIT 1;
8 $$ LANGUAGE SQL STABLE;
9
10 COMMIT: