1-- 2-- regproc 3-- 4 5/* If objects exist, return oids */ 6 7CREATE ROLE regress_regrole_test; 8 9-- without schemaname 10 11SELECT regoper('||/'); 12SELECT regoperator('+(int4,int4)'); 13SELECT regproc('now'); 14SELECT regprocedure('abs(numeric)'); 15SELECT regclass('pg_class'); 16SELECT regtype('int4'); 17SELECT regcollation('"POSIX"'); 18 19SELECT to_regoper('||/'); 20SELECT to_regoperator('+(int4,int4)'); 21SELECT to_regproc('now'); 22SELECT to_regprocedure('abs(numeric)'); 23SELECT to_regclass('pg_class'); 24SELECT to_regtype('int4'); 25SELECT to_regcollation('"POSIX"'); 26 27-- with schemaname 28 29SELECT regoper('pg_catalog.||/'); 30SELECT regoperator('pg_catalog.+(int4,int4)'); 31SELECT regproc('pg_catalog.now'); 32SELECT regprocedure('pg_catalog.abs(numeric)'); 33SELECT regclass('pg_catalog.pg_class'); 34SELECT regtype('pg_catalog.int4'); 35SELECT regcollation('pg_catalog."POSIX"'); 36 37SELECT to_regoper('pg_catalog.||/'); 38SELECT to_regproc('pg_catalog.now'); 39SELECT to_regprocedure('pg_catalog.abs(numeric)'); 40SELECT to_regclass('pg_catalog.pg_class'); 41SELECT to_regtype('pg_catalog.int4'); 42SELECT to_regcollation('pg_catalog."POSIX"'); 43 44-- schemaname not applicable 45 46SELECT regrole('regress_regrole_test'); 47SELECT regrole('"regress_regrole_test"'); 48SELECT regnamespace('pg_catalog'); 49SELECT regnamespace('"pg_catalog"'); 50 51SELECT to_regrole('regress_regrole_test'); 52SELECT to_regrole('"regress_regrole_test"'); 53SELECT to_regnamespace('pg_catalog'); 54SELECT to_regnamespace('"pg_catalog"'); 55 56/* If objects don't exist, raise errors. */ 57 58DROP ROLE regress_regrole_test; 59 60-- without schemaname 61 62SELECT regoper('||//'); 63SELECT regoperator('++(int4,int4)'); 64SELECT regproc('know'); 65SELECT regprocedure('absinthe(numeric)'); 66SELECT regclass('pg_classes'); 67SELECT regtype('int3'); 68 69-- with schemaname 70 71SELECT regoper('ng_catalog.||/'); 72SELECT regoperator('ng_catalog.+(int4,int4)'); 73SELECT regproc('ng_catalog.now'); 74SELECT regprocedure('ng_catalog.abs(numeric)'); 75SELECT regclass('ng_catalog.pg_class'); 76SELECT regtype('ng_catalog.int4'); 77SELECT regcollation('ng_catalog."POSIX"'); 78 79-- schemaname not applicable 80 81SELECT regrole('regress_regrole_test'); 82SELECT regrole('"regress_regrole_test"'); 83SELECT regrole('Nonexistent'); 84SELECT regrole('"Nonexistent"'); 85SELECT regrole('foo.bar'); 86SELECT regnamespace('Nonexistent'); 87SELECT regnamespace('"Nonexistent"'); 88SELECT regnamespace('foo.bar'); 89 90/* If objects don't exist, return NULL with no error. */ 91 92-- without schemaname 93 94SELECT to_regoper('||//'); 95SELECT to_regoperator('++(int4,int4)'); 96SELECT to_regproc('know'); 97SELECT to_regprocedure('absinthe(numeric)'); 98SELECT to_regclass('pg_classes'); 99SELECT to_regtype('int3'); 100SELECT to_regcollation('notacollation'); 101 102-- with schemaname 103 104SELECT to_regoper('ng_catalog.||/'); 105SELECT to_regoperator('ng_catalog.+(int4,int4)'); 106SELECT to_regproc('ng_catalog.now'); 107SELECT to_regprocedure('ng_catalog.abs(numeric)'); 108SELECT to_regclass('ng_catalog.pg_class'); 109SELECT to_regtype('ng_catalog.int4'); 110SELECT to_regcollation('ng_catalog."POSIX"'); 111 112-- schemaname not applicable 113 114SELECT to_regrole('regress_regrole_test'); 115SELECT to_regrole('"regress_regrole_test"'); 116SELECT to_regrole('foo.bar'); 117SELECT to_regrole('Nonexistent'); 118SELECT to_regrole('"Nonexistent"'); 119SELECT to_regrole('foo.bar'); 120SELECT to_regnamespace('Nonexistent'); 121SELECT to_regnamespace('"Nonexistent"'); 122SELECT to_regnamespace('foo.bar'); 123