/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/test/modules/test_ddl_deparse/expected/create_view.out
25 строк
950 B
Michael Paquier
Add some tests for CREATE OR REPLACE VIEW with column additions
04 мар 2026, 03:55
04 мар 2026, 03:55
9ef6381
Код
Авторство
О чём код?
-- -- CREATE_VIEW -- CREATE VIEW static_view AS SELECT 'foo'::TEXT AS col; NOTICE: DDL test: type simple, tag CREATE VIEW CREATE OR REPLACE VIEW static_view AS SELECT 'bar'::TEXT AS col; NOTICE: DDL test: type simple, tag CREATE VIEW NOTICE: DDL test: type alter table, tag CREATE VIEW NOTICE: subcommand: type REPLACE RELOPTIONS desc <NULL> CREATE VIEW datatype_view AS SELECT * FROM datatype_table; NOTICE: DDL test: type simple, tag CREATE VIEW CREATE OR REPLACE VIEW datatype_view AS SELECT * FROM datatype_table, static_view; NOTICE: DDL test: type simple, tag CREATE VIEW NOTICE: DDL test: type alter table, tag CREATE VIEW NOTICE: subcommand: type ADD COLUMN TO VIEW desc column col of view datatype_view NOTICE: subcommand: type REPLACE RELOPTIONS desc <NULL> CREATE RECURSIVE VIEW nums_1_100 (n) AS VALUES (1) UNION ALL SELECT n+1 FROM nums_1_100 WHERE n < 100; NOTICE: DDL test: type simple, tag CREATE VIEW