| /dports/databases/postgresql12-plpython/postgresql-12.9/contrib/intarray/ |
| H A D | intarray--unpackaged--1.0.sql | 6 ALTER EXTENSION intarray ADD type query_int;
7 ALTER EXTENSION intarray ADD function bqarr_in(cstring);
8 ALTER EXTENSION intarray ADD function bqarr_out(query_int);
9 ALTER EXTENSION intarray ADD function querytree(query_int);
26 ALTER EXTENSION intarray ADD function intset(integer);
27 ALTER EXTENSION intarray ADD function icount(integer[]);
28 ALTER EXTENSION intarray ADD operator #(NONE,integer[]);
30 ALTER EXTENSION intarray ADD function sort(integer[]);
31 ALTER EXTENSION intarray ADD function sort_asc(integer[]);
33 ALTER EXTENSION intarray ADD function uniq(integer[]);
[all …]
|
| /dports/databases/postgresql12-server/postgresql-12.9/contrib/intarray/ |
| H A D | intarray--unpackaged--1.0.sql | 6 ALTER EXTENSION intarray ADD type query_int;
7 ALTER EXTENSION intarray ADD function bqarr_in(cstring);
8 ALTER EXTENSION intarray ADD function bqarr_out(query_int);
9 ALTER EXTENSION intarray ADD function querytree(query_int);
26 ALTER EXTENSION intarray ADD function intset(integer);
27 ALTER EXTENSION intarray ADD function icount(integer[]);
28 ALTER EXTENSION intarray ADD operator #(NONE,integer[]);
30 ALTER EXTENSION intarray ADD function sort(integer[]);
31 ALTER EXTENSION intarray ADD function sort_asc(integer[]);
33 ALTER EXTENSION intarray ADD function uniq(integer[]);
[all …]
|
| /dports/databases/postgis31/postgis-3.1.4/extensions/postgis_tiger_geocoder/sql_bits/ |
| H A D | tiger_geocoder--unpackaged.sql.in | 66 ALTER EXTENSION postgis_tiger_geocoder ADD table addr;
67 ALTER EXTENSION postgis_tiger_geocoder ADD table addrfeat;
68 ALTER EXTENSION postgis_tiger_geocoder ADD table county;
71 ALTER EXTENSION postgis_tiger_geocoder ADD table cousub;
73 ALTER EXTENSION postgis_tiger_geocoder ADD table edges;
74 ALTER EXTENSION postgis_tiger_geocoder ADD table faces;
80 ALTER EXTENSION postgis_tiger_geocoder ADD table pagc_gaz;
83 ALTER EXTENSION postgis_tiger_geocoder ADD table place;
86 ALTER EXTENSION postgis_tiger_geocoder ADD table state;
89 ALTER EXTENSION postgis_tiger_geocoder ADD table zcta5;
[all …]
|
| /dports/databases/postgis32/postgis-3.2.0/extensions/postgis_tiger_geocoder/sql_bits/ |
| H A D | tiger_geocoder--unpackaged.sql.in | 66 ALTER EXTENSION postgis_tiger_geocoder ADD table addr;
67 ALTER EXTENSION postgis_tiger_geocoder ADD table addrfeat;
68 ALTER EXTENSION postgis_tiger_geocoder ADD table county;
71 ALTER EXTENSION postgis_tiger_geocoder ADD table cousub;
73 ALTER EXTENSION postgis_tiger_geocoder ADD table edges;
74 ALTER EXTENSION postgis_tiger_geocoder ADD table faces;
80 ALTER EXTENSION postgis_tiger_geocoder ADD table pagc_gaz;
83 ALTER EXTENSION postgis_tiger_geocoder ADD table place;
86 ALTER EXTENSION postgis_tiger_geocoder ADD table state;
89 ALTER EXTENSION postgis_tiger_geocoder ADD table zcta5;
[all …]
|
| /dports/databases/postgis30/postgis-3.0.4/extensions/postgis_tiger_geocoder/sql_bits/ |
| H A D | tiger_geocoder--unpackaged.sql.in | 66 ALTER EXTENSION postgis_tiger_geocoder ADD table addr;
67 ALTER EXTENSION postgis_tiger_geocoder ADD table addrfeat;
68 ALTER EXTENSION postgis_tiger_geocoder ADD table county;
71 ALTER EXTENSION postgis_tiger_geocoder ADD table cousub;
73 ALTER EXTENSION postgis_tiger_geocoder ADD table edges;
74 ALTER EXTENSION postgis_tiger_geocoder ADD table faces;
80 ALTER EXTENSION postgis_tiger_geocoder ADD table pagc_gaz;
83 ALTER EXTENSION postgis_tiger_geocoder ADD table place;
86 ALTER EXTENSION postgis_tiger_geocoder ADD table state;
89 ALTER EXTENSION postgis_tiger_geocoder ADD table zcta5;
[all …]
|
| /dports/databases/postgis25/postgis-2.5.5/extensions/postgis_tiger_geocoder/sql_bits/ |
| H A D | tiger_geocoder--unpackaged.sql.in | 66 ALTER EXTENSION postgis_tiger_geocoder ADD table addr;
67 ALTER EXTENSION postgis_tiger_geocoder ADD table addrfeat;
68 ALTER EXTENSION postgis_tiger_geocoder ADD table county;
71 ALTER EXTENSION postgis_tiger_geocoder ADD table cousub;
73 ALTER EXTENSION postgis_tiger_geocoder ADD table edges;
74 ALTER EXTENSION postgis_tiger_geocoder ADD table faces;
80 ALTER EXTENSION postgis_tiger_geocoder ADD table pagc_gaz;
83 ALTER EXTENSION postgis_tiger_geocoder ADD table place;
86 ALTER EXTENSION postgis_tiger_geocoder ADD table state;
89 ALTER EXTENSION postgis_tiger_geocoder ADD table zcta5;
[all …]
|
| /dports/databases/pg_similarity/pg_similarity-be1a8b0/ |
| H A D | pg_similarity--unpackaged--1.0.sql | 5 ALTER EXTENSION pg_similarity ADD function block(text, text);
6 ALTER EXTENSION pg_similarity ADD function block_op(text, text);
7 ALTER EXTENSION pg_similarity ADD operator ~++(text, text);
10 ALTER EXTENSION pg_similarity ADD function cosine(text, text);
12 ALTER EXTENSION pg_similarity ADD operator ~##(text, text);
15 ALTER EXTENSION pg_similarity ADD function dice(text, text);
17 ALTER EXTENSION pg_similarity ADD operator ~-~(text, text);
22 ALTER EXTENSION pg_similarity ADD operator ~!!(text, text);
29 ALTER EXTENSION pg_similarity ADD operator ~@~(text, text);
34 ALTER EXTENSION pg_similarity ADD operator ~??(text, text);
[all …]
|
| /dports/databases/pg_citus/citus-10.2.3/src/test/regress/sql/ |
| H A D | multi_extension.sql | 100 DROP EXTENSION citus;
435 DROP EXTENSION citus;
494 DROP EXTENSION citus;
496 CREATE EXTENSION citus;
501 DROP EXTENSION citus;
516 DROP EXTENSION Citus;
528 CREATE EXTENSION Citus;
543 DROP EXTENSION citus;
546 CREATE EXTENSION citus;
554 DROP EXTENSION citus;
[all …]
|
| /dports/databases/postgresql96-server/postgresql-9.6.24/contrib/btree_gist/ |
| H A D | btree_gist--unpackaged--1.0.sql | 6 ALTER EXTENSION btree_gist ADD type gbtreekey4;
7 ALTER EXTENSION btree_gist ADD function gbtreekey4_in(cstring);
8 ALTER EXTENSION btree_gist ADD function gbtreekey4_out(gbtreekey4);
9 ALTER EXTENSION btree_gist ADD type gbtreekey8;
10 ALTER EXTENSION btree_gist ADD function gbtreekey8_in(cstring);
11 ALTER EXTENSION btree_gist ADD function gbtreekey8_out(gbtreekey8);
12 ALTER EXTENSION btree_gist ADD type gbtreekey16;
13 ALTER EXTENSION btree_gist ADD function gbtreekey16_in(cstring);
15 ALTER EXTENSION btree_gist ADD type gbtreekey32;
16 ALTER EXTENSION btree_gist ADD function gbtreekey32_in(cstring);
[all …]
|
| /dports/databases/postgresql96-pltcl/postgresql-9.6.24/contrib/btree_gist/ |
| H A D | btree_gist--unpackaged--1.0.sql | 6 ALTER EXTENSION btree_gist ADD type gbtreekey4;
7 ALTER EXTENSION btree_gist ADD function gbtreekey4_in(cstring);
8 ALTER EXTENSION btree_gist ADD function gbtreekey4_out(gbtreekey4);
9 ALTER EXTENSION btree_gist ADD type gbtreekey8;
10 ALTER EXTENSION btree_gist ADD function gbtreekey8_in(cstring);
11 ALTER EXTENSION btree_gist ADD function gbtreekey8_out(gbtreekey8);
12 ALTER EXTENSION btree_gist ADD type gbtreekey16;
13 ALTER EXTENSION btree_gist ADD function gbtreekey16_in(cstring);
15 ALTER EXTENSION btree_gist ADD type gbtreekey32;
16 ALTER EXTENSION btree_gist ADD function gbtreekey32_in(cstring);
[all …]
|
| /dports/databases/postgresql96-plpython/postgresql-9.6.24/contrib/btree_gist/ |
| H A D | btree_gist--unpackaged--1.0.sql | 6 ALTER EXTENSION btree_gist ADD type gbtreekey4;
7 ALTER EXTENSION btree_gist ADD function gbtreekey4_in(cstring);
8 ALTER EXTENSION btree_gist ADD function gbtreekey4_out(gbtreekey4);
9 ALTER EXTENSION btree_gist ADD type gbtreekey8;
10 ALTER EXTENSION btree_gist ADD function gbtreekey8_in(cstring);
11 ALTER EXTENSION btree_gist ADD function gbtreekey8_out(gbtreekey8);
12 ALTER EXTENSION btree_gist ADD type gbtreekey16;
13 ALTER EXTENSION btree_gist ADD function gbtreekey16_in(cstring);
15 ALTER EXTENSION btree_gist ADD type gbtreekey32;
16 ALTER EXTENSION btree_gist ADD function gbtreekey32_in(cstring);
[all …]
|
| /dports/databases/postgresql10-plpython/postgresql-10.19/contrib/btree_gist/ |
| H A D | btree_gist--unpackaged--1.0.sql | 6 ALTER EXTENSION btree_gist ADD type gbtreekey4;
7 ALTER EXTENSION btree_gist ADD function gbtreekey4_in(cstring);
8 ALTER EXTENSION btree_gist ADD function gbtreekey4_out(gbtreekey4);
9 ALTER EXTENSION btree_gist ADD type gbtreekey8;
10 ALTER EXTENSION btree_gist ADD function gbtreekey8_in(cstring);
11 ALTER EXTENSION btree_gist ADD function gbtreekey8_out(gbtreekey8);
12 ALTER EXTENSION btree_gist ADD type gbtreekey16;
13 ALTER EXTENSION btree_gist ADD function gbtreekey16_in(cstring);
15 ALTER EXTENSION btree_gist ADD type gbtreekey32;
16 ALTER EXTENSION btree_gist ADD function gbtreekey32_in(cstring);
[all …]
|
| /dports/databases/postgresql10-plperl/postgresql-10.19/contrib/btree_gist/ |
| H A D | btree_gist--unpackaged--1.0.sql | 6 ALTER EXTENSION btree_gist ADD type gbtreekey4;
7 ALTER EXTENSION btree_gist ADD function gbtreekey4_in(cstring);
8 ALTER EXTENSION btree_gist ADD function gbtreekey4_out(gbtreekey4);
9 ALTER EXTENSION btree_gist ADD type gbtreekey8;
10 ALTER EXTENSION btree_gist ADD function gbtreekey8_in(cstring);
11 ALTER EXTENSION btree_gist ADD function gbtreekey8_out(gbtreekey8);
12 ALTER EXTENSION btree_gist ADD type gbtreekey16;
13 ALTER EXTENSION btree_gist ADD function gbtreekey16_in(cstring);
15 ALTER EXTENSION btree_gist ADD type gbtreekey32;
16 ALTER EXTENSION btree_gist ADD function gbtreekey32_in(cstring);
[all …]
|
| /dports/databases/postgresql10-docs/postgresql-10.19/contrib/btree_gist/ |
| H A D | btree_gist--unpackaged--1.0.sql | 6 ALTER EXTENSION btree_gist ADD type gbtreekey4;
7 ALTER EXTENSION btree_gist ADD function gbtreekey4_in(cstring);
8 ALTER EXTENSION btree_gist ADD function gbtreekey4_out(gbtreekey4);
9 ALTER EXTENSION btree_gist ADD type gbtreekey8;
10 ALTER EXTENSION btree_gist ADD function gbtreekey8_in(cstring);
11 ALTER EXTENSION btree_gist ADD function gbtreekey8_out(gbtreekey8);
12 ALTER EXTENSION btree_gist ADD type gbtreekey16;
13 ALTER EXTENSION btree_gist ADD function gbtreekey16_in(cstring);
15 ALTER EXTENSION btree_gist ADD type gbtreekey32;
16 ALTER EXTENSION btree_gist ADD function gbtreekey32_in(cstring);
[all …]
|
| /dports/databases/postgresql10-client/postgresql-10.19/contrib/btree_gist/ |
| H A D | btree_gist--unpackaged--1.0.sql | 6 ALTER EXTENSION btree_gist ADD type gbtreekey4;
7 ALTER EXTENSION btree_gist ADD function gbtreekey4_in(cstring);
8 ALTER EXTENSION btree_gist ADD function gbtreekey4_out(gbtreekey4);
9 ALTER EXTENSION btree_gist ADD type gbtreekey8;
10 ALTER EXTENSION btree_gist ADD function gbtreekey8_in(cstring);
11 ALTER EXTENSION btree_gist ADD function gbtreekey8_out(gbtreekey8);
12 ALTER EXTENSION btree_gist ADD type gbtreekey16;
13 ALTER EXTENSION btree_gist ADD function gbtreekey16_in(cstring);
15 ALTER EXTENSION btree_gist ADD type gbtreekey32;
16 ALTER EXTENSION btree_gist ADD function gbtreekey32_in(cstring);
[all …]
|
| /dports/databases/postgresql10-contrib/postgresql-10.19/contrib/btree_gist/ |
| H A D | btree_gist--unpackaged--1.0.sql | 6 ALTER EXTENSION btree_gist ADD type gbtreekey4;
7 ALTER EXTENSION btree_gist ADD function gbtreekey4_in(cstring);
8 ALTER EXTENSION btree_gist ADD function gbtreekey4_out(gbtreekey4);
9 ALTER EXTENSION btree_gist ADD type gbtreekey8;
10 ALTER EXTENSION btree_gist ADD function gbtreekey8_in(cstring);
11 ALTER EXTENSION btree_gist ADD function gbtreekey8_out(gbtreekey8);
12 ALTER EXTENSION btree_gist ADD type gbtreekey16;
13 ALTER EXTENSION btree_gist ADD function gbtreekey16_in(cstring);
15 ALTER EXTENSION btree_gist ADD type gbtreekey32;
16 ALTER EXTENSION btree_gist ADD function gbtreekey32_in(cstring);
[all …]
|
| /dports/databases/postgresql10-pltcl/postgresql-10.19/contrib/btree_gist/ |
| H A D | btree_gist--unpackaged--1.0.sql | 6 ALTER EXTENSION btree_gist ADD type gbtreekey4;
7 ALTER EXTENSION btree_gist ADD function gbtreekey4_in(cstring);
8 ALTER EXTENSION btree_gist ADD function gbtreekey4_out(gbtreekey4);
9 ALTER EXTENSION btree_gist ADD type gbtreekey8;
10 ALTER EXTENSION btree_gist ADD function gbtreekey8_in(cstring);
11 ALTER EXTENSION btree_gist ADD function gbtreekey8_out(gbtreekey8);
12 ALTER EXTENSION btree_gist ADD type gbtreekey16;
13 ALTER EXTENSION btree_gist ADD function gbtreekey16_in(cstring);
15 ALTER EXTENSION btree_gist ADD type gbtreekey32;
16 ALTER EXTENSION btree_gist ADD function gbtreekey32_in(cstring);
[all …]
|
| /dports/databases/postgresql11-docs/postgresql-11.14/contrib/btree_gist/ |
| H A D | btree_gist--unpackaged--1.0.sql | 6 ALTER EXTENSION btree_gist ADD type gbtreekey4;
7 ALTER EXTENSION btree_gist ADD function gbtreekey4_in(cstring);
8 ALTER EXTENSION btree_gist ADD function gbtreekey4_out(gbtreekey4);
9 ALTER EXTENSION btree_gist ADD type gbtreekey8;
10 ALTER EXTENSION btree_gist ADD function gbtreekey8_in(cstring);
11 ALTER EXTENSION btree_gist ADD function gbtreekey8_out(gbtreekey8);
12 ALTER EXTENSION btree_gist ADD type gbtreekey16;
13 ALTER EXTENSION btree_gist ADD function gbtreekey16_in(cstring);
15 ALTER EXTENSION btree_gist ADD type gbtreekey32;
16 ALTER EXTENSION btree_gist ADD function gbtreekey32_in(cstring);
[all …]
|
| /dports/databases/postgresql11-plperl/postgresql-11.14/contrib/btree_gist/ |
| H A D | btree_gist--unpackaged--1.0.sql | 6 ALTER EXTENSION btree_gist ADD type gbtreekey4;
7 ALTER EXTENSION btree_gist ADD function gbtreekey4_in(cstring);
8 ALTER EXTENSION btree_gist ADD function gbtreekey4_out(gbtreekey4);
9 ALTER EXTENSION btree_gist ADD type gbtreekey8;
10 ALTER EXTENSION btree_gist ADD function gbtreekey8_in(cstring);
11 ALTER EXTENSION btree_gist ADD function gbtreekey8_out(gbtreekey8);
12 ALTER EXTENSION btree_gist ADD type gbtreekey16;
13 ALTER EXTENSION btree_gist ADD function gbtreekey16_in(cstring);
15 ALTER EXTENSION btree_gist ADD type gbtreekey32;
16 ALTER EXTENSION btree_gist ADD function gbtreekey32_in(cstring);
[all …]
|
| /dports/databases/postgresql11-plpython/postgresql-11.14/contrib/btree_gist/ |
| H A D | btree_gist--unpackaged--1.0.sql | 6 ALTER EXTENSION btree_gist ADD type gbtreekey4;
7 ALTER EXTENSION btree_gist ADD function gbtreekey4_in(cstring);
8 ALTER EXTENSION btree_gist ADD function gbtreekey4_out(gbtreekey4);
9 ALTER EXTENSION btree_gist ADD type gbtreekey8;
10 ALTER EXTENSION btree_gist ADD function gbtreekey8_in(cstring);
11 ALTER EXTENSION btree_gist ADD function gbtreekey8_out(gbtreekey8);
12 ALTER EXTENSION btree_gist ADD type gbtreekey16;
13 ALTER EXTENSION btree_gist ADD function gbtreekey16_in(cstring);
15 ALTER EXTENSION btree_gist ADD type gbtreekey32;
16 ALTER EXTENSION btree_gist ADD function gbtreekey32_in(cstring);
[all …]
|
| /dports/databases/postgresql11-server/postgresql-11.14/contrib/btree_gist/ |
| H A D | btree_gist--unpackaged--1.0.sql | 6 ALTER EXTENSION btree_gist ADD type gbtreekey4;
7 ALTER EXTENSION btree_gist ADD function gbtreekey4_in(cstring);
8 ALTER EXTENSION btree_gist ADD function gbtreekey4_out(gbtreekey4);
9 ALTER EXTENSION btree_gist ADD type gbtreekey8;
10 ALTER EXTENSION btree_gist ADD function gbtreekey8_in(cstring);
11 ALTER EXTENSION btree_gist ADD function gbtreekey8_out(gbtreekey8);
12 ALTER EXTENSION btree_gist ADD type gbtreekey16;
13 ALTER EXTENSION btree_gist ADD function gbtreekey16_in(cstring);
15 ALTER EXTENSION btree_gist ADD type gbtreekey32;
16 ALTER EXTENSION btree_gist ADD function gbtreekey32_in(cstring);
[all …]
|
| /dports/databases/postgresql11-contrib/postgresql-11.14/contrib/btree_gist/ |
| H A D | btree_gist--unpackaged--1.0.sql | 6 ALTER EXTENSION btree_gist ADD type gbtreekey4;
7 ALTER EXTENSION btree_gist ADD function gbtreekey4_in(cstring);
8 ALTER EXTENSION btree_gist ADD function gbtreekey4_out(gbtreekey4);
9 ALTER EXTENSION btree_gist ADD type gbtreekey8;
10 ALTER EXTENSION btree_gist ADD function gbtreekey8_in(cstring);
11 ALTER EXTENSION btree_gist ADD function gbtreekey8_out(gbtreekey8);
12 ALTER EXTENSION btree_gist ADD type gbtreekey16;
13 ALTER EXTENSION btree_gist ADD function gbtreekey16_in(cstring);
15 ALTER EXTENSION btree_gist ADD type gbtreekey32;
16 ALTER EXTENSION btree_gist ADD function gbtreekey32_in(cstring);
[all …]
|
| /dports/databases/postgresql10-server/postgresql-10.19/contrib/btree_gist/ |
| H A D | btree_gist--unpackaged--1.0.sql | 6 ALTER EXTENSION btree_gist ADD type gbtreekey4;
7 ALTER EXTENSION btree_gist ADD function gbtreekey4_in(cstring);
8 ALTER EXTENSION btree_gist ADD function gbtreekey4_out(gbtreekey4);
9 ALTER EXTENSION btree_gist ADD type gbtreekey8;
10 ALTER EXTENSION btree_gist ADD function gbtreekey8_in(cstring);
11 ALTER EXTENSION btree_gist ADD function gbtreekey8_out(gbtreekey8);
12 ALTER EXTENSION btree_gist ADD type gbtreekey16;
13 ALTER EXTENSION btree_gist ADD function gbtreekey16_in(cstring);
15 ALTER EXTENSION btree_gist ADD type gbtreekey32;
16 ALTER EXTENSION btree_gist ADD function gbtreekey32_in(cstring);
[all …]
|
| /dports/databases/postgresql11-client/postgresql-11.14/contrib/btree_gist/ |
| H A D | btree_gist--unpackaged--1.0.sql | 6 ALTER EXTENSION btree_gist ADD type gbtreekey4;
7 ALTER EXTENSION btree_gist ADD function gbtreekey4_in(cstring);
8 ALTER EXTENSION btree_gist ADD function gbtreekey4_out(gbtreekey4);
9 ALTER EXTENSION btree_gist ADD type gbtreekey8;
10 ALTER EXTENSION btree_gist ADD function gbtreekey8_in(cstring);
11 ALTER EXTENSION btree_gist ADD function gbtreekey8_out(gbtreekey8);
12 ALTER EXTENSION btree_gist ADD type gbtreekey16;
13 ALTER EXTENSION btree_gist ADD function gbtreekey16_in(cstring);
15 ALTER EXTENSION btree_gist ADD type gbtreekey32;
16 ALTER EXTENSION btree_gist ADD function gbtreekey32_in(cstring);
[all …]
|
| /dports/databases/postgresql12-contrib/postgresql-12.9/contrib/btree_gist/ |
| H A D | btree_gist--unpackaged--1.0.sql | 6 ALTER EXTENSION btree_gist ADD type gbtreekey4;
7 ALTER EXTENSION btree_gist ADD function gbtreekey4_in(cstring);
8 ALTER EXTENSION btree_gist ADD function gbtreekey4_out(gbtreekey4);
9 ALTER EXTENSION btree_gist ADD type gbtreekey8;
10 ALTER EXTENSION btree_gist ADD function gbtreekey8_in(cstring);
11 ALTER EXTENSION btree_gist ADD function gbtreekey8_out(gbtreekey8);
12 ALTER EXTENSION btree_gist ADD type gbtreekey16;
13 ALTER EXTENSION btree_gist ADD function gbtreekey16_in(cstring);
15 ALTER EXTENSION btree_gist ADD type gbtreekey32;
16 ALTER EXTENSION btree_gist ADD function gbtreekey32_in(cstring);
[all …]
|