/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 79 TRUNCATE guid1; 80 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 81 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 82 SELECT count(DISTINCT guid_field) FROM guid1; [all …]
|
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 79 TRUNCATE guid1; 80 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 81 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 82 SELECT count(DISTINCT guid_field) FROM guid1; [all …]
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 79 TRUNCATE guid1; 80 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 81 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 82 SELECT count(DISTINCT guid_field) FROM guid1; [all …]
|
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 79 TRUNCATE guid1; 80 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 81 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 82 SELECT count(DISTINCT guid_field) FROM guid1; [all …]
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 79 TRUNCATE guid1; 80 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 81 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 82 SELECT count(DISTINCT guid_field) FROM guid1; [all …]
|
/dports/databases/postgresql13-plpython/postgresql-13.5/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 79 TRUNCATE guid1; 80 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 81 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 82 SELECT count(DISTINCT guid_field) FROM guid1; [all …]
|
/dports/databases/postgresql13-pltcl/postgresql-13.5/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 79 TRUNCATE guid1; 80 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 81 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 82 SELECT count(DISTINCT guid_field) FROM guid1; [all …]
|
/dports/databases/postgresql14-client/postgresql-14.1/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 79 TRUNCATE guid1; 80 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 81 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 82 SELECT count(DISTINCT guid_field) FROM guid1; [all …]
|
/dports/databases/postgresql14-contrib/postgresql-14.1/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 79 TRUNCATE guid1; 80 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 81 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 82 SELECT count(DISTINCT guid_field) FROM guid1; [all …]
|
/dports/databases/postgresql13-server/postgresql-13.5/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 79 TRUNCATE guid1; 80 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 81 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 82 SELECT count(DISTINCT guid_field) FROM guid1; [all …]
|
/dports/databases/postgresql13-contrib/postgresql-13.5/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 79 TRUNCATE guid1; 80 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 81 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 82 SELECT count(DISTINCT guid_field) FROM guid1; [all …]
|
/dports/databases/postgresql13-client/postgresql-13.5/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 79 TRUNCATE guid1; 80 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 81 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 82 SELECT count(DISTINCT guid_field) FROM guid1; [all …]
|
/dports/databases/postgresql13-docs/postgresql-13.5/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 79 TRUNCATE guid1; 80 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 81 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 82 SELECT count(DISTINCT guid_field) FROM guid1; [all …]
|
/dports/databases/postgresql13-plperl/postgresql-13.5/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 79 TRUNCATE guid1; 80 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 81 INSERT INTO guid1 (guid_field) VALUES (gen_random_uuid()); 82 SELECT count(DISTINCT guid_field) FROM guid1; [all …]
|
/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 16 INSERT INTO guid1(guid_field) VALUES('11111111-1111-1111-1111-111111111111F'); 18 INSERT INTO guid1(guid_field) VALUES('{11111111-1111-1111-1111-11111111111}'); 29 INSERT INTO guid1(guid_field) VALUES('3f3e3c3b3a3039383736353433a2313e'); 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 61 CREATE UNIQUE INDEX guid1_unique_BTREE ON guid1 USING BTREE (guid_field); [all …]
|
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 16 INSERT INTO guid1(guid_field) VALUES('11111111-1111-1111-1111-111111111111F'); 18 INSERT INTO guid1(guid_field) VALUES('{11111111-1111-1111-1111-11111111111}'); 29 INSERT INTO guid1(guid_field) VALUES('3f3e3c3b3a3039383736353433a2313e'); 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 61 CREATE UNIQUE INDEX guid1_unique_BTREE ON guid1 USING BTREE (guid_field); [all …]
|
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 ( table 50 guid1; 56 guid1 63 guid1 71 guid1 79 guid1 87 guid1 95 guid1 103 guid1 111 guid1 [all …]
|
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 16 INSERT INTO guid1(guid_field) VALUES('11111111-1111-1111-1111-111111111111F'); 18 INSERT INTO guid1(guid_field) VALUES('{11111111-1111-1111-1111-11111111111}'); 29 INSERT INTO guid1(guid_field) VALUES('3f3e3c3b3a3039383736353433a2313e'); 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 61 CREATE UNIQUE INDEX guid1_unique_BTREE ON guid1 USING BTREE (guid_field); [all …]
|
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 16 INSERT INTO guid1(guid_field) VALUES('11111111-1111-1111-1111-111111111111F'); 18 INSERT INTO guid1(guid_field) VALUES('{11111111-1111-1111-1111-11111111111}'); 29 INSERT INTO guid1(guid_field) VALUES('3f3e3c3b3a3039383736353433a2313e'); 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 61 CREATE UNIQUE INDEX guid1_unique_BTREE ON guid1 USING BTREE (guid_field); [all …]
|
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 16 INSERT INTO guid1(guid_field) VALUES('11111111-1111-1111-1111-111111111111F'); 18 INSERT INTO guid1(guid_field) VALUES('{11111111-1111-1111-1111-11111111111}'); 29 INSERT INTO guid1(guid_field) VALUES('3f3e3c3b3a3039383736353433a2313e'); 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 61 CREATE UNIQUE INDEX guid1_unique_BTREE ON guid1 USING BTREE (guid_field); [all …]
|
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 16 INSERT INTO guid1(guid_field) VALUES('11111111-1111-1111-1111-111111111111F'); 18 INSERT INTO guid1(guid_field) VALUES('{11111111-1111-1111-1111-11111111111}'); 29 INSERT INTO guid1(guid_field) VALUES('3f3e3c3b3a3039383736353433a2313e'); 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 61 CREATE UNIQUE INDEX guid1_unique_BTREE ON guid1 USING BTREE (guid_field); [all …]
|
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 16 INSERT INTO guid1(guid_field) VALUES('11111111-1111-1111-1111-111111111111F'); 18 INSERT INTO guid1(guid_field) VALUES('{11111111-1111-1111-1111-11111111111}'); 29 INSERT INTO guid1(guid_field) VALUES('3f3e3c3b3a3039383736353433a2313e'); 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 61 CREATE UNIQUE INDEX guid1_unique_BTREE ON guid1 USING BTREE (guid_field); [all …]
|
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 16 INSERT INTO guid1(guid_field) VALUES('11111111-1111-1111-1111-111111111111F'); 18 INSERT INTO guid1(guid_field) VALUES('{11111111-1111-1111-1111-11111111111}'); 29 INSERT INTO guid1(guid_field) VALUES('3f3e3c3b3a3039383736353433a2313e'); 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 61 CREATE UNIQUE INDEX guid1_unique_BTREE ON guid1 USING BTREE (guid_field); [all …]
|
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 16 INSERT INTO guid1(guid_field) VALUES('11111111-1111-1111-1111-111111111111F'); 18 INSERT INTO guid1(guid_field) VALUES('{11111111-1111-1111-1111-11111111111}'); 29 INSERT INTO guid1(guid_field) VALUES('3f3e3c3b3a3039383736353433a2313e'); 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 61 CREATE UNIQUE INDEX guid1_unique_BTREE ON guid1 USING BTREE (guid_field); [all …]
|
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/ |
H A D | uuid.sql | 3 CREATE TABLE guid1 table 16 INSERT INTO guid1(guid_field) VALUES('11111111-1111-1111-1111-111111111111F'); 18 INSERT INTO guid1(guid_field) VALUES('{11111111-1111-1111-1111-11111111111}'); 29 INSERT INTO guid1(guid_field) VALUES('3f3e3c3b3a3039383736353433a2313e'); 32 SELECT guid_field FROM guid1; 35 SELECT guid_field FROM guid1 ORDER BY guid_field ASC; 36 SELECT guid_field FROM guid1 ORDER BY guid_field DESC; 57 CREATE INDEX guid1_btree ON guid1 USING BTREE (guid_field); 58 CREATE INDEX guid1_hash ON guid1 USING HASH (guid_field); 61 CREATE UNIQUE INDEX guid1_unique_BTREE ON guid1 USING BTREE (guid_field); [all …]
|