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