src/test/regress/sql/select_views.sql


1
2
3
4
5
6
7
8
9
10
11

--
-- VIEW queries
--
-- test the views defined in create.source
--
SELECT * FROM street;

SELECT name, #thepath FROM iexit ORDER BY 1, 2;

SELECT * FROM toyemp WHERE name = 'sharon';