summaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/pg_catalog/pg_operator.sql
blob: 526764c1a31f44383d9cec65a313acd9fbe41558 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
--!syntax_pg
select 
    min(oid) as min_oid, 
    min(oprcom) as min_oprcom, 
    min(oprleft) as min_oprleft, 
    min(oprname) as min_oprname, 
    min(oprnamespace) as min_oprnamespace, 
    min(oprnegate) as min_oprnegate, 
    min(oprowner) as min_oprowner, 
    min(oprresult) as min_oprresult,
    min(oprright) as min_oprright,
    
    max(oid) as max_oid, 
    max(oprcom) as max_oprcom, 
    max(oprleft) as max_oprleft, 
    max(oprname) as max_oprname, 
    max(oprnamespace) as max_oprnamespace, 
    max(oprnegate) as max_oprnegate, 
    max(oprowner) as max_oprowner, 
    max(oprresult) as max_oprresult,
    max(oprright) as max_oprright
from pg_operator;