| /dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
| H A D | with.sql | 2120 ALTER TABLE withz
2124 INSERT INTO withz
2147 INSERT INTO withz
2165 withz
2177 INSERT INTO withz
2194 INSERT INTO withz
2210 INSERT INTO withz
2231 INSERT INTO withz
2248 INSERT INTO withz
2275 INSERT INTO withz
[all …]
|
| /dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
| H A D | with.sql | 809 ALTER TABLE withz ADD UNIQUE (k);
812 INSERT INTO withz SELECT i, 'insert'
822 WHERE withz.k != EXCLUDED.k
828 SELECT * FROM withz ORDER BY k;
835 INSERT INTO withz VALUES(1, 'insert')
838 INSERT INTO withz VALUES(1, 'insert')
841 INSERT INTO withz VALUES(1, 'insert')
844 INSERT INTO withz VALUES(1, 'insert')
856 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
859 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/ |
| H A D | with.sql | 834 ALTER TABLE withz ADD UNIQUE (k);
837 INSERT INTO withz SELECT i, 'insert'
847 WHERE withz.k != EXCLUDED.k
853 SELECT * FROM withz ORDER BY k;
860 INSERT INTO withz VALUES(1, 'insert')
863 INSERT INTO withz VALUES(1, 'insert')
866 INSERT INTO withz VALUES(1, 'insert')
869 INSERT INTO withz VALUES(1, 'insert')
881 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
884 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/ |
| H A D | with.sql | 834 ALTER TABLE withz ADD UNIQUE (k);
837 INSERT INTO withz SELECT i, 'insert'
847 WHERE withz.k != EXCLUDED.k
853 SELECT * FROM withz ORDER BY k;
860 INSERT INTO withz VALUES(1, 'insert')
863 INSERT INTO withz VALUES(1, 'insert')
866 INSERT INTO withz VALUES(1, 'insert')
869 INSERT INTO withz VALUES(1, 'insert')
881 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
884 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/ |
| H A D | with.sql | 834 ALTER TABLE withz ADD UNIQUE (k);
837 INSERT INTO withz SELECT i, 'insert'
847 WHERE withz.k != EXCLUDED.k
853 SELECT * FROM withz ORDER BY k;
860 INSERT INTO withz VALUES(1, 'insert')
863 INSERT INTO withz VALUES(1, 'insert')
866 INSERT INTO withz VALUES(1, 'insert')
869 INSERT INTO withz VALUES(1, 'insert')
881 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
884 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/ |
| H A D | with.sql | 834 ALTER TABLE withz ADD UNIQUE (k);
837 INSERT INTO withz SELECT i, 'insert'
847 WHERE withz.k != EXCLUDED.k
853 SELECT * FROM withz ORDER BY k;
860 INSERT INTO withz VALUES(1, 'insert')
863 INSERT INTO withz VALUES(1, 'insert')
866 INSERT INTO withz VALUES(1, 'insert')
869 INSERT INTO withz VALUES(1, 'insert')
881 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
884 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/ |
| H A D | with.sql | 834 ALTER TABLE withz ADD UNIQUE (k);
837 INSERT INTO withz SELECT i, 'insert'
847 WHERE withz.k != EXCLUDED.k
853 SELECT * FROM withz ORDER BY k;
860 INSERT INTO withz VALUES(1, 'insert')
863 INSERT INTO withz VALUES(1, 'insert')
866 INSERT INTO withz VALUES(1, 'insert')
869 INSERT INTO withz VALUES(1, 'insert')
881 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
884 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/ |
| H A D | with.sql | 834 ALTER TABLE withz ADD UNIQUE (k);
837 INSERT INTO withz SELECT i, 'insert'
847 WHERE withz.k != EXCLUDED.k
853 SELECT * FROM withz ORDER BY k;
860 INSERT INTO withz VALUES(1, 'insert')
863 INSERT INTO withz VALUES(1, 'insert')
866 INSERT INTO withz VALUES(1, 'insert')
869 INSERT INTO withz VALUES(1, 'insert')
881 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
884 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/ |
| H A D | with.sql | 834 ALTER TABLE withz ADD UNIQUE (k);
837 INSERT INTO withz SELECT i, 'insert'
847 WHERE withz.k != EXCLUDED.k
853 SELECT * FROM withz ORDER BY k;
860 INSERT INTO withz VALUES(1, 'insert')
863 INSERT INTO withz VALUES(1, 'insert')
866 INSERT INTO withz VALUES(1, 'insert')
869 INSERT INTO withz VALUES(1, 'insert')
881 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
884 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql11-server/postgresql-11.14/src/test/regress/sql/ |
| H A D | with.sql | 834 ALTER TABLE withz ADD UNIQUE (k);
837 INSERT INTO withz SELECT i, 'insert'
847 WHERE withz.k != EXCLUDED.k
853 SELECT * FROM withz ORDER BY k;
860 INSERT INTO withz VALUES(1, 'insert')
863 INSERT INTO withz VALUES(1, 'insert')
866 INSERT INTO withz VALUES(1, 'insert')
869 INSERT INTO withz VALUES(1, 'insert')
881 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
884 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql13-plpython/postgresql-13.5/src/test/regress/sql/ |
| H A D | with.sql | 878 ALTER TABLE withz ADD UNIQUE (k);
881 INSERT INTO withz SELECT i, 'insert'
891 WHERE withz.k != EXCLUDED.k
897 SELECT * FROM withz ORDER BY k;
904 INSERT INTO withz VALUES(1, 'insert')
907 INSERT INTO withz VALUES(1, 'insert')
910 INSERT INTO withz VALUES(1, 'insert')
913 INSERT INTO withz VALUES(1, 'insert')
925 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
928 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql13-pltcl/postgresql-13.5/src/test/regress/sql/ |
| H A D | with.sql | 878 ALTER TABLE withz ADD UNIQUE (k);
881 INSERT INTO withz SELECT i, 'insert'
891 WHERE withz.k != EXCLUDED.k
897 SELECT * FROM withz ORDER BY k;
904 INSERT INTO withz VALUES(1, 'insert')
907 INSERT INTO withz VALUES(1, 'insert')
910 INSERT INTO withz VALUES(1, 'insert')
913 INSERT INTO withz VALUES(1, 'insert')
925 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
928 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql13-server/postgresql-13.5/src/test/regress/sql/ |
| H A D | with.sql | 878 ALTER TABLE withz ADD UNIQUE (k);
881 INSERT INTO withz SELECT i, 'insert'
891 WHERE withz.k != EXCLUDED.k
897 SELECT * FROM withz ORDER BY k;
904 INSERT INTO withz VALUES(1, 'insert')
907 INSERT INTO withz VALUES(1, 'insert')
910 INSERT INTO withz VALUES(1, 'insert')
913 INSERT INTO withz VALUES(1, 'insert')
925 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
928 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql13-contrib/postgresql-13.5/src/test/regress/sql/ |
| H A D | with.sql | 878 ALTER TABLE withz ADD UNIQUE (k);
881 INSERT INTO withz SELECT i, 'insert'
891 WHERE withz.k != EXCLUDED.k
897 SELECT * FROM withz ORDER BY k;
904 INSERT INTO withz VALUES(1, 'insert')
907 INSERT INTO withz VALUES(1, 'insert')
910 INSERT INTO withz VALUES(1, 'insert')
913 INSERT INTO withz VALUES(1, 'insert')
925 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
928 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql12-server/postgresql-12.9/src/test/regress/sql/ |
| H A D | with.sql | 834 ALTER TABLE withz ADD UNIQUE (k);
837 INSERT INTO withz SELECT i, 'insert'
847 WHERE withz.k != EXCLUDED.k
853 SELECT * FROM withz ORDER BY k;
860 INSERT INTO withz VALUES(1, 'insert')
863 INSERT INTO withz VALUES(1, 'insert')
866 INSERT INTO withz VALUES(1, 'insert')
869 INSERT INTO withz VALUES(1, 'insert')
881 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
884 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql12-plpython/postgresql-12.9/src/test/regress/sql/ |
| H A D | with.sql | 834 ALTER TABLE withz ADD UNIQUE (k);
837 INSERT INTO withz SELECT i, 'insert'
847 WHERE withz.k != EXCLUDED.k
853 SELECT * FROM withz ORDER BY k;
860 INSERT INTO withz VALUES(1, 'insert')
863 INSERT INTO withz VALUES(1, 'insert')
866 INSERT INTO withz VALUES(1, 'insert')
869 INSERT INTO withz VALUES(1, 'insert')
881 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
884 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql13-client/postgresql-13.5/src/test/regress/sql/ |
| H A D | with.sql | 878 ALTER TABLE withz ADD UNIQUE (k);
881 INSERT INTO withz SELECT i, 'insert'
891 WHERE withz.k != EXCLUDED.k
897 SELECT * FROM withz ORDER BY k;
904 INSERT INTO withz VALUES(1, 'insert')
907 INSERT INTO withz VALUES(1, 'insert')
910 INSERT INTO withz VALUES(1, 'insert')
913 INSERT INTO withz VALUES(1, 'insert')
925 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
928 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql12-docs/postgresql-12.9/src/test/regress/sql/ |
| H A D | with.sql | 834 ALTER TABLE withz ADD UNIQUE (k);
837 INSERT INTO withz SELECT i, 'insert'
847 WHERE withz.k != EXCLUDED.k
853 SELECT * FROM withz ORDER BY k;
860 INSERT INTO withz VALUES(1, 'insert')
863 INSERT INTO withz VALUES(1, 'insert')
866 INSERT INTO withz VALUES(1, 'insert')
869 INSERT INTO withz VALUES(1, 'insert')
881 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
884 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql12-contrib/postgresql-12.9/src/test/regress/sql/ |
| H A D | with.sql | 834 ALTER TABLE withz ADD UNIQUE (k);
837 INSERT INTO withz SELECT i, 'insert'
847 WHERE withz.k != EXCLUDED.k
853 SELECT * FROM withz ORDER BY k;
860 INSERT INTO withz VALUES(1, 'insert')
863 INSERT INTO withz VALUES(1, 'insert')
866 INSERT INTO withz VALUES(1, 'insert')
869 INSERT INTO withz VALUES(1, 'insert')
881 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
884 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql12-plperl/postgresql-12.9/src/test/regress/sql/ |
| H A D | with.sql | 834 ALTER TABLE withz ADD UNIQUE (k);
837 INSERT INTO withz SELECT i, 'insert'
847 WHERE withz.k != EXCLUDED.k
853 SELECT * FROM withz ORDER BY k;
860 INSERT INTO withz VALUES(1, 'insert')
863 INSERT INTO withz VALUES(1, 'insert')
866 INSERT INTO withz VALUES(1, 'insert')
869 INSERT INTO withz VALUES(1, 'insert')
881 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
884 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql12-pltcl/postgresql-12.9/src/test/regress/sql/ |
| H A D | with.sql | 834 ALTER TABLE withz ADD UNIQUE (k);
837 INSERT INTO withz SELECT i, 'insert'
847 WHERE withz.k != EXCLUDED.k
853 SELECT * FROM withz ORDER BY k;
860 INSERT INTO withz VALUES(1, 'insert')
863 INSERT INTO withz VALUES(1, 'insert')
866 INSERT INTO withz VALUES(1, 'insert')
869 INSERT INTO withz VALUES(1, 'insert')
881 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
884 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql13-plperl/postgresql-13.5/src/test/regress/sql/ |
| H A D | with.sql | 878 ALTER TABLE withz ADD UNIQUE (k);
881 INSERT INTO withz SELECT i, 'insert'
891 WHERE withz.k != EXCLUDED.k
897 SELECT * FROM withz ORDER BY k;
904 INSERT INTO withz VALUES(1, 'insert')
907 INSERT INTO withz VALUES(1, 'insert')
910 INSERT INTO withz VALUES(1, 'insert')
913 INSERT INTO withz VALUES(1, 'insert')
925 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
928 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql13-docs/postgresql-13.5/src/test/regress/sql/ |
| H A D | with.sql | 878 ALTER TABLE withz ADD UNIQUE (k);
881 INSERT INTO withz SELECT i, 'insert'
891 WHERE withz.k != EXCLUDED.k
897 SELECT * FROM withz ORDER BY k;
904 INSERT INTO withz VALUES(1, 'insert')
907 INSERT INTO withz VALUES(1, 'insert')
910 INSERT INTO withz VALUES(1, 'insert')
913 INSERT INTO withz VALUES(1, 'insert')
925 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
928 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/ |
| H A D | with.sql | 1209 ALTER TABLE withz ADD UNIQUE (k);
1212 INSERT INTO withz SELECT i, 'insert'
1222 WHERE withz.k != EXCLUDED.k
1228 SELECT * FROM withz ORDER BY k;
1235 INSERT INTO withz VALUES(1, 'insert')
1238 INSERT INTO withz VALUES(1, 'insert')
1241 INSERT INTO withz VALUES(1, 'insert')
1244 INSERT INTO withz VALUES(1, 'insert')
1256 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
1259 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|
| /dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/ |
| H A D | with.sql | 1209 ALTER TABLE withz ADD UNIQUE (k);
1212 INSERT INTO withz SELECT i, 'insert'
1222 WHERE withz.k != EXCLUDED.k
1228 SELECT * FROM withz ORDER BY k;
1235 INSERT INTO withz VALUES(1, 'insert')
1238 INSERT INTO withz VALUES(1, 'insert')
1241 INSERT INTO withz VALUES(1, 'insert')
1244 INSERT INTO withz VALUES(1, 'insert')
1256 INSERT INTO withz VALUES(2, 'Blue') ON CONFLICT (k) DO
1259 INSERT INTO withz VALUES(2, 'Red') ON CONFLICT (k) DO
[all …]
|