| /dports/databases/postgresql13-pltcl/postgresql-13.5/src/test/regress/sql/ |
| H A D | type_sanity.sql | 77 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
82 LEFT JOIN pg_range as r ON rngtypid = p1.oid
347 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
349 (t.typanalyze = 'range_typanalyze'::regproc) != (r.rngtypid IS NOT NULL);
436 SELECT p1.rngtypid, p1.rngsubtype
438 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
442 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
449 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
459 SELECT p1.rngtypid, p1.rngsubtype, p.proname
461 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
[all …]
|
| /dports/databases/postgresql13-plpython/postgresql-13.5/src/test/regress/sql/ |
| H A D | type_sanity.sql | 77 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
82 LEFT JOIN pg_range as r ON rngtypid = p1.oid
347 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
349 (t.typanalyze = 'range_typanalyze'::regproc) != (r.rngtypid IS NOT NULL);
436 SELECT p1.rngtypid, p1.rngsubtype
438 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
442 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
449 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
459 SELECT p1.rngtypid, p1.rngsubtype, p.proname
461 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
[all …]
|
| /dports/databases/postgresql96-docs/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | type_sanity.sql | 77 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
82 LEFT JOIN pg_range as r ON rngtypid = p1.oid
321 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
323 (t.typanalyze = 'range_typanalyze'::regproc) != (r.rngtypid IS NOT NULL);
393 SELECT p1.rngtypid, p1.rngsubtype
395 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
399 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
406 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
416 SELECT p1.rngtypid, p1.rngsubtype, p.proname
418 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
[all …]
|
| /dports/databases/postgresql96-client/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | type_sanity.sql | 77 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
82 LEFT JOIN pg_range as r ON rngtypid = p1.oid
321 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
323 (t.typanalyze = 'range_typanalyze'::regproc) != (r.rngtypid IS NOT NULL);
393 SELECT p1.rngtypid, p1.rngsubtype
395 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
399 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
406 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
416 SELECT p1.rngtypid, p1.rngsubtype, p.proname
418 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
[all …]
|
| /dports/databases/postgresql96-contrib/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | type_sanity.sql | 77 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
82 LEFT JOIN pg_range as r ON rngtypid = p1.oid
321 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
323 (t.typanalyze = 'range_typanalyze'::regproc) != (r.rngtypid IS NOT NULL);
393 SELECT p1.rngtypid, p1.rngsubtype
395 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
399 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
406 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
416 SELECT p1.rngtypid, p1.rngsubtype, p.proname
418 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
[all …]
|
| /dports/databases/postgresql13-contrib/postgresql-13.5/src/test/regress/sql/ |
| H A D | type_sanity.sql | 77 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
82 LEFT JOIN pg_range as r ON rngtypid = p1.oid
347 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
349 (t.typanalyze = 'range_typanalyze'::regproc) != (r.rngtypid IS NOT NULL);
436 SELECT p1.rngtypid, p1.rngsubtype
438 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
442 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
449 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
459 SELECT p1.rngtypid, p1.rngsubtype, p.proname
461 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
[all …]
|
| /dports/databases/postgresql12-server/postgresql-12.9/src/test/regress/sql/ |
| H A D | type_sanity.sql | 77 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
82 LEFT JOIN pg_range as r ON rngtypid = p1.oid
345 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
347 (t.typanalyze = 'range_typanalyze'::regproc) != (r.rngtypid IS NOT NULL);
434 SELECT p1.rngtypid, p1.rngsubtype
436 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
440 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
447 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
457 SELECT p1.rngtypid, p1.rngsubtype, p.proname
459 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
[all …]
|
| /dports/databases/postgresql13-client/postgresql-13.5/src/test/regress/sql/ |
| H A D | type_sanity.sql | 77 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
82 LEFT JOIN pg_range as r ON rngtypid = p1.oid
347 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
349 (t.typanalyze = 'range_typanalyze'::regproc) != (r.rngtypid IS NOT NULL);
436 SELECT p1.rngtypid, p1.rngsubtype
438 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
442 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
449 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
459 SELECT p1.rngtypid, p1.rngsubtype, p.proname
461 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
[all …]
|
| /dports/databases/postgresql12-docs/postgresql-12.9/src/test/regress/sql/ |
| H A D | type_sanity.sql | 77 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
82 LEFT JOIN pg_range as r ON rngtypid = p1.oid
345 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
347 (t.typanalyze = 'range_typanalyze'::regproc) != (r.rngtypid IS NOT NULL);
434 SELECT p1.rngtypid, p1.rngsubtype
436 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
440 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
447 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
457 SELECT p1.rngtypid, p1.rngsubtype, p.proname
459 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
[all …]
|
| /dports/databases/postgresql12-plpython/postgresql-12.9/src/test/regress/sql/ |
| H A D | type_sanity.sql | 77 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
82 LEFT JOIN pg_range as r ON rngtypid = p1.oid
345 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
347 (t.typanalyze = 'range_typanalyze'::regproc) != (r.rngtypid IS NOT NULL);
434 SELECT p1.rngtypid, p1.rngsubtype
436 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
440 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
447 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
457 SELECT p1.rngtypid, p1.rngsubtype, p.proname
459 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
[all …]
|
| /dports/databases/postgresql12-contrib/postgresql-12.9/src/test/regress/sql/ |
| H A D | type_sanity.sql | 77 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
82 LEFT JOIN pg_range as r ON rngtypid = p1.oid
345 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
347 (t.typanalyze = 'range_typanalyze'::regproc) != (r.rngtypid IS NOT NULL);
434 SELECT p1.rngtypid, p1.rngsubtype
436 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
440 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
447 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
457 SELECT p1.rngtypid, p1.rngsubtype, p.proname
459 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
[all …]
|
| /dports/databases/postgresql12-plperl/postgresql-12.9/src/test/regress/sql/ |
| H A D | type_sanity.sql | 77 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
82 LEFT JOIN pg_range as r ON rngtypid = p1.oid
345 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
347 (t.typanalyze = 'range_typanalyze'::regproc) != (r.rngtypid IS NOT NULL);
434 SELECT p1.rngtypid, p1.rngsubtype
436 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
440 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
447 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
457 SELECT p1.rngtypid, p1.rngsubtype, p.proname
459 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
[all …]
|
| /dports/databases/postgresql13-docs/postgresql-13.5/src/test/regress/sql/ |
| H A D | type_sanity.sql | 77 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
82 LEFT JOIN pg_range as r ON rngtypid = p1.oid
347 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
349 (t.typanalyze = 'range_typanalyze'::regproc) != (r.rngtypid IS NOT NULL);
436 SELECT p1.rngtypid, p1.rngsubtype
438 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
442 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
449 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
459 SELECT p1.rngtypid, p1.rngsubtype, p.proname
461 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
[all …]
|
| /dports/databases/postgresql13-plperl/postgresql-13.5/src/test/regress/sql/ |
| H A D | type_sanity.sql | 77 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
82 LEFT JOIN pg_range as r ON rngtypid = p1.oid
347 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
349 (t.typanalyze = 'range_typanalyze'::regproc) != (r.rngtypid IS NOT NULL);
436 SELECT p1.rngtypid, p1.rngsubtype
438 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
442 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
449 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
459 SELECT p1.rngtypid, p1.rngsubtype, p.proname
461 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
[all …]
|
| /dports/databases/postgresql12-pltcl/postgresql-12.9/src/test/regress/sql/ |
| H A D | type_sanity.sql | 77 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
82 LEFT JOIN pg_range as r ON rngtypid = p1.oid
345 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
347 (t.typanalyze = 'range_typanalyze'::regproc) != (r.rngtypid IS NOT NULL);
434 SELECT p1.rngtypid, p1.rngsubtype
436 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
440 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
447 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
457 SELECT p1.rngtypid, p1.rngsubtype, p.proname
459 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
[all …]
|
| /dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/ |
| H A D | type_sanity.sql | 78 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
83 LEFT JOIN pg_range as r ON rngtypid = p1.oid
368 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
457 SELECT p1.rngtypid, p1.rngsubtype
459 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
463 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
470 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
481 SELECT p1.rngtypid, p1.rngsubtype, p.proname
483 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
487 SELECT p1.rngtypid, p1.rngsubtype, p.proname
[all …]
|
| /dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/ |
| H A D | type_sanity.sql | 78 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
83 LEFT JOIN pg_range as r ON rngtypid = p1.oid
368 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
457 SELECT p1.rngtypid, p1.rngsubtype
459 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
463 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
470 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
481 SELECT p1.rngtypid, p1.rngsubtype, p.proname
483 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
487 SELECT p1.rngtypid, p1.rngsubtype, p.proname
[all …]
|
| /dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/ |
| H A D | type_sanity.sql | 78 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
83 LEFT JOIN pg_range as r ON rngtypid = p1.oid
368 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
457 SELECT p1.rngtypid, p1.rngsubtype
459 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
463 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
470 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
481 SELECT p1.rngtypid, p1.rngsubtype, p.proname
483 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
487 SELECT p1.rngtypid, p1.rngsubtype, p.proname
[all …]
|
| /dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/ |
| H A D | type_sanity.sql | 78 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
83 LEFT JOIN pg_range as r ON rngtypid = p1.oid
368 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
457 SELECT p1.rngtypid, p1.rngsubtype
459 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
463 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
470 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
481 SELECT p1.rngtypid, p1.rngsubtype, p.proname
483 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
487 SELECT p1.rngtypid, p1.rngsubtype, p.proname
[all …]
|
| /dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/ |
| H A D | type_sanity.sql | 78 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
83 LEFT JOIN pg_range as r ON rngtypid = p1.oid
368 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
457 SELECT p1.rngtypid, p1.rngsubtype
459 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
463 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
470 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
481 SELECT p1.rngtypid, p1.rngsubtype, p.proname
483 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
487 SELECT p1.rngtypid, p1.rngsubtype, p.proname
[all …]
|
| /dports/databases/postgresql14-client/postgresql-14.1/src/test/regress/sql/ |
| H A D | type_sanity.sql | 78 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
83 LEFT JOIN pg_range as r ON rngtypid = p1.oid
368 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
457 SELECT p1.rngtypid, p1.rngsubtype
459 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
463 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
470 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
481 SELECT p1.rngtypid, p1.rngsubtype, p.proname
483 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
487 SELECT p1.rngtypid, p1.rngsubtype, p.proname
[all …]
|
| /dports/databases/postgresql14-contrib/postgresql-14.1/src/test/regress/sql/ |
| H A D | type_sanity.sql | 78 NOT EXISTS(SELECT 1 FROM pg_range r WHERE rngtypid = p1.oid);
83 LEFT JOIN pg_range as r ON rngtypid = p1.oid
368 FROM pg_type t LEFT JOIN pg_range r on t.oid = r.rngtypid
457 SELECT p1.rngtypid, p1.rngsubtype
459 WHERE p1.rngtypid = 0 OR p1.rngsubtype = 0 OR p1.rngsubopc = 0;
463 SELECT p1.rngtypid, p1.rngsubtype, p1.rngcollation, t.typcollation
470 SELECT p1.rngtypid, p1.rngsubtype, o.opcmethod, o.opcname
481 SELECT p1.rngtypid, p1.rngsubtype, p.proname
483 WHERE pronargs != 1 OR proargtypes[0] != rngtypid OR prorettype != rngtypid;
487 SELECT p1.rngtypid, p1.rngsubtype, p.proname
[all …]
|
| /dports/databases/postgresql14-pltcl/postgresql-14.1/src/include/catalog/ |
| H A D | pg_range.h | 32 Oid rngtypid BKI_LOOKUP(pg_type);
60 DECLARE_UNIQUE_INDEX_PKEY(pg_range_rngtypid_index, 3542, on pg_range using btree(rngtypid oid_ops));
|
| /dports/databases/postgresql14-server/postgresql-14.1/src/include/catalog/ |
| H A D | pg_range.h | 32 Oid rngtypid BKI_LOOKUP(pg_type);
60 DECLARE_UNIQUE_INDEX_PKEY(pg_range_rngtypid_index, 3542, on pg_range using btree(rngtypid oid_ops));
|
| /dports/databases/postgresql14-docs/postgresql-14.1/src/include/catalog/ |
| H A D | pg_range.h | 32 Oid rngtypid BKI_LOOKUP(pg_type);
60 DECLARE_UNIQUE_INDEX_PKEY(pg_range_rngtypid_index, 3542, on pg_range using btree(rngtypid oid_ops));
|