src/test/regress/sql/select_views.sql


1
2
3
4
5
6
7
8
9
10
11

--
-- SELECT_VIEWS
-- test the views defined in CREATE_VIEWS
--

SELECT * FROM street;

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

SELECT * FROM toyemp WHERE name = 'sharon';