src/test/modules/test_ddl_deparse/sql/create_view.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

--
-- CREATE_VIEW
--

CREATE VIEW static_view AS
  SELECT 'foo'::TEXT AS col;

CREATE OR REPLACE VIEW static_view AS
  SELECT 'bar'::TEXT AS col;

CREATE VIEW datatype_view AS
  SELECT * FROM datatype_table;

CREATE RECURSIVE VIEW nums_1_100 (n) AS
    VALUES (1)
UNION ALL
    SELECT n+1 FROM nums_1_100 WHERE n < 100;