blob: 4ae0f4978ec1ac7bb1db357d1f0c2ea5b41a6da8 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
--
-- 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 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
|
