/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
H A D | matview.sql | 12 CREATE VIEW mvtest_tv AS 31 ) CREATE MATERIALIZED VIEW mvtest_tm AS 40 CREATE MATERIALIZED VIEW mvtest_tm AS 63 REFRESH MATERIALIZED VIEW mvtest_tm; 92 CREATE MATERIALIZED VIEW mvtest_tvm AS 123 CREATE VIEW mvtest_tvv AS 143 CREATE VIEW mvtest_tvvmv AS 149 CREATE MATERIALIZED VIEW mvtest_bb AS 332 CREATE VIEW mvtest_vt1 AS 336 CREATE VIEW mvtest_vt2 AS [all …]
|
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql14-contrib/postgresql-14.1/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql14-client/postgresql-14.1/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/graphics/figurine/figurine-1.0.5/src/ |
H A D | mouse_motion.c | 98 toggle(VIEW(l2),last_x, last_y); in handle_motion() 108 toggle(VIEW(l2),last_x, last_y); in handle_motion() 125 …if (get_nearest_point(VIEW(l2),VIEW(l2)->doc->o, XP2D(mouse_x,VIEW(l2)),YP2D(mouse_y,VIEW(l2)),&x,… in handle_motion() 127 mouse_x = XD2P(x,VIEW(l2)); in handle_motion() 128 mouse_y = YD2P(y,VIEW(l2)); in handle_motion() 136 test = nudge_ruler_x(VIEW(l2)->ruler_x_window, VIEW(l2), LEFT); in handle_motion() 138 test = nudge_ruler_x(VIEW(l2)->ruler_x_window, VIEW(l2), RIGHT); in handle_motion() 141 test2 = nudge_ruler_y(VIEW(l2)->ruler_y_window, VIEW(l2), UP); in handle_motion() 143 test2 = nudge_ruler_y(VIEW(l2)->ruler_y_window, VIEW(l2), DOWN); in handle_motion() 148 redraw_view_window(VIEW(l2)); in handle_motion() [all …]
|
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|
/dports/databases/postgresql11-server/postgresql-11.14/src/test/regress/sql/ |
H A D | matview.sql | 20 REFRESH MATERIALIZED VIEW mvtest_tm; 63 REFRESH MATERIALIZED VIEW mvtest_tvm; 78 REFRESH MATERIALIZED VIEW mvtest_tmm; 80 REFRESH MATERIALIZED VIEW mvtest_tvmm; 81 REFRESH MATERIALIZED VIEW mvtest_tvvm; 115 CREATE VIEW mvtest_vt1 AS SELECT 1 moo; 123 DROP VIEW mvtest_vt1 CASCADE; 130 REFRESH MATERIALIZED VIEW mvtest_mv; 142 REFRESH MATERIALIZED VIEW mvtest_mv; 176 REFRESH MATERIALIZED VIEW mvtest_mv_v; [all …]
|