github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/functions.align-deindent.golden (about) 1 // Code generated by TestPretty. DO NOT EDIT. 2 // GENERATED FILE DO NOT EDIT 3 1: 4 - 5 SELECT 6 min( 7 a, 8 b 9 ), 10 min( 11 DISTINCT 12 a, 13 b 14 ), 15 min(), 16 min() OVER (), 17 min() OVER ( 18 ORDER BY 19 x 20 ), 21 min() FILTER ( 22 WHERE 23 x 24 > 3 25 AND y 26 < 4 27 ), 28 min() FILTER ( 29 WHERE 30 x 31 > 3 32 AND y 33 < 4 34 ) OVER ( 35 ORDER BY 36 x 37 ), 38 min() OVER ( 39 RANGE 40 BETWEEN 41 UNBOUNDED PRECEDING 42 AND 43 UNBOUNDED FOLLOWING 44 ), 45 min() OVER ( 46 ROWS 47 BETWEEN 48 1 FOLLOWING 49 AND 50 1 FOLLOWING 51 ), 52 min() OVER ( 53 w 54 PARTITION BY 55 a, 56 b 57 ORDER BY 58 x, 59 y 60 ROWS 61 BETWEEN 62 1 FOLLOWING 63 AND 64 1 FOLLOWING 65 ) 66 67 11: 68 ----------- 69 SELECT min( 70 a, 71 b 72 ), 73 min( 74 DISTINCT 75 a, 76 b 77 ), 78 min(), 79 min() OVER (), 80 min() OVER ( 81 ORDER BY 82 x 83 ), 84 min() FILTER ( 85 WHERE 86 x 87 > 3 88 AND y 89 < 4 90 ), 91 min() FILTER ( 92 WHERE 93 x 94 > 3 95 AND y 96 < 4 97 ) OVER ( 98 ORDER BY 99 x 100 ), 101 min() OVER ( 102 RANGE 103 BETWEEN 104 UNBOUNDED PRECEDING 105 AND 106 UNBOUNDED FOLLOWING 107 ), 108 min() OVER ( 109 ROWS 110 BETWEEN 111 1 FOLLOWING 112 AND 113 1 FOLLOWING 114 ), 115 min() OVER ( 116 w 117 PARTITION BY 118 a, 119 b 120 ORDER BY 121 x, 122 y 123 ROWS 124 BETWEEN 125 1 FOLLOWING 126 AND 127 1 FOLLOWING 128 ) 129 130 15: 131 --------------- 132 SELECT min( 133 a, 134 b 135 ), 136 min( 137 DISTINCT 138 a, 139 b 140 ), 141 min(), 142 min() OVER (), 143 min() OVER ( 144 ORDER BY 145 x 146 ), 147 min() FILTER ( 148 WHERE x 149 > 3 150 AND y 151 < 4 152 ), 153 min() FILTER ( 154 WHERE x 155 > 3 156 AND y 157 < 4 158 ) OVER ( 159 ORDER BY 160 x 161 ), 162 min() OVER ( 163 RANGE 164 BETWEEN 165 UNBOUNDED PRECEDING 166 AND 167 UNBOUNDED FOLLOWING 168 ), 169 min() OVER ( 170 ROWS 171 BETWEEN 172 1 FOLLOWING 173 AND 174 1 FOLLOWING 175 ), 176 min() OVER ( 177 w 178 PARTITION BY 179 a, 180 b 181 ORDER BY 182 x, 183 y 184 ROWS 185 BETWEEN 186 1 FOLLOWING 187 AND 188 1 FOLLOWING 189 ) 190 191 16: 192 ---------------- 193 SELECT min( 194 a, 195 b 196 ), 197 min( 198 DISTINCT 199 a, 200 b 201 ), 202 min(), 203 min() OVER (), 204 min() OVER ( 205 ORDER BY 206 x 207 ), 208 min() FILTER ( 209 WHERE x 210 > 3 211 AND y 212 < 4 213 ), 214 min() FILTER ( 215 WHERE x 216 > 3 217 AND y 218 < 4 219 ) OVER ( 220 ORDER BY 221 x 222 ), 223 min() OVER ( 224 RANGE 225 BETWEEN 226 UNBOUNDED PRECEDING 227 AND 228 UNBOUNDED FOLLOWING 229 ), 230 min() OVER ( 231 ROWS 232 BETWEEN 233 1 FOLLOWING 234 AND 235 1 FOLLOWING 236 ), 237 min() OVER ( 238 w 239 PARTITION BY 240 a, b 241 ORDER BY 242 x, y 243 ROWS 244 BETWEEN 245 1 FOLLOWING 246 AND 247 1 FOLLOWING 248 ) 249 250 17: 251 ----------------- 252 SELECT min(a, b), 253 min( 254 DISTINCT 255 a, 256 b 257 ), 258 min(), 259 min() OVER (), 260 min() OVER ( 261 ORDER BY 262 x 263 ), 264 min() FILTER ( 265 WHERE x 266 > 3 267 AND y 268 < 4 269 ), 270 min() FILTER ( 271 WHERE x 272 > 3 273 AND y 274 < 4 275 ) OVER ( 276 ORDER BY 277 x 278 ), 279 min() OVER ( 280 RANGE 281 BETWEEN 282 UNBOUNDED PRECEDING 283 AND 284 UNBOUNDED FOLLOWING 285 ), 286 min() OVER ( 287 ROWS 288 BETWEEN 289 1 FOLLOWING 290 AND 291 1 FOLLOWING 292 ), 293 min() OVER ( 294 w 295 PARTITION BY 296 a, b 297 ORDER BY 298 x, y 299 ROWS 300 BETWEEN 301 1 FOLLOWING 302 AND 303 1 FOLLOWING 304 ) 305 306 18: 307 ------------------ 308 SELECT min(a, b), 309 min( 310 DISTINCT 311 a, 312 b 313 ), 314 min(), 315 min() OVER (), 316 min() OVER ( 317 ORDER BY x 318 ), 319 min() FILTER ( 320 WHERE x 321 > 3 322 AND y 323 < 4 324 ), 325 min() FILTER ( 326 WHERE x 327 > 3 328 AND y 329 < 4 330 ) OVER ( 331 ORDER BY x 332 ), 333 min() OVER ( 334 RANGE 335 BETWEEN 336 UNBOUNDED PRECEDING 337 AND 338 UNBOUNDED FOLLOWING 339 ), 340 min() OVER ( 341 ROWS 342 BETWEEN 343 1 FOLLOWING 344 AND 345 1 FOLLOWING 346 ), 347 min() OVER ( 348 w 349 PARTITION BY 350 a, b 351 ORDER BY 352 x, y 353 ROWS 354 BETWEEN 355 1 FOLLOWING 356 AND 357 1 FOLLOWING 358 ) 359 360 19: 361 ------------------- 362 SELECT min(a, b), 363 min( 364 DISTINCT 365 a, 366 b 367 ), 368 min(), 369 min() OVER (), 370 min() OVER ( 371 ORDER BY x 372 ), 373 min() FILTER ( 374 WHERE x > 3 375 AND y < 4 376 ), 377 min() FILTER ( 378 WHERE x > 3 379 AND y < 4 380 ) OVER ( 381 ORDER BY x 382 ), 383 min() OVER ( 384 RANGE 385 BETWEEN 386 UNBOUNDED PRECEDING 387 AND 388 UNBOUNDED FOLLOWING 389 ), 390 min() OVER ( 391 ROWS 392 BETWEEN 393 1 FOLLOWING 394 AND 395 1 FOLLOWING 396 ), 397 min() OVER ( 398 w 399 PARTITION BY 400 a, b 401 ORDER BY 402 x, y 403 ROWS 404 BETWEEN 405 1 FOLLOWING 406 AND 407 1 FOLLOWING 408 ) 409 410 20: 411 -------------------- 412 SELECT min(a, b), 413 min( 414 DISTINCT 415 a, 416 b 417 ), 418 min(), 419 min() OVER (), 420 min() OVER ( 421 ORDER BY x 422 ), 423 min() FILTER ( 424 WHERE x > 3 425 AND y < 4 426 ), 427 min() FILTER ( 428 WHERE x > 3 429 AND y < 4 430 ) OVER ( 431 ORDER BY x 432 ), 433 min() OVER ( 434 RANGE 435 BETWEEN 436 UNBOUNDED PRECEDING 437 AND 438 UNBOUNDED FOLLOWING 439 ), 440 min() OVER ( 441 ROWS BETWEEN 442 1 FOLLOWING 443 AND 444 1 FOLLOWING 445 ), 446 min() OVER ( 447 w 448 PARTITION BY 449 a, b 450 ORDER BY 451 x, y 452 ROWS 453 BETWEEN 454 1 FOLLOWING 455 AND 456 1 FOLLOWING 457 ) 458 459 21: 460 --------------------- 461 SELECT min(a, b), 462 min( 463 DISTINCT 464 a, 465 b 466 ), 467 min(), 468 min() OVER (), 469 min() OVER ( 470 ORDER BY x 471 ), 472 min() FILTER ( 473 WHERE x > 3 474 AND y < 4 475 ), 476 min() FILTER ( 477 WHERE x > 3 478 AND y < 4 479 ) OVER ( 480 ORDER BY x 481 ), 482 min() OVER ( 483 RANGE BETWEEN 484 UNBOUNDED PRECEDING 485 AND 486 UNBOUNDED FOLLOWING 487 ), 488 min() OVER ( 489 ROWS BETWEEN 490 1 FOLLOWING 491 AND 492 1 FOLLOWING 493 ), 494 min() OVER ( 495 w 496 PARTITION BY 497 a, b 498 ORDER BY 499 x, y 500 ROWS 501 BETWEEN 502 1 FOLLOWING 503 AND 504 1 FOLLOWING 505 ) 506 507 22: 508 ---------------------- 509 SELECT min(a, b), 510 min( 511 DISTINCT 512 a, 513 b 514 ), 515 min(), 516 min() OVER (), 517 min() OVER ( 518 ORDER BY x 519 ), 520 min() FILTER ( 521 WHERE x > 3 522 AND y < 4 523 ), 524 min() FILTER ( 525 WHERE x > 3 526 AND y < 4 527 ) OVER ( 528 ORDER BY x 529 ), 530 min() OVER ( 531 RANGE BETWEEN 532 UNBOUNDED PRECEDING 533 AND 534 UNBOUNDED FOLLOWING 535 ), 536 min() OVER ( 537 ROWS BETWEEN 538 1 FOLLOWING 539 AND 540 1 FOLLOWING 541 ), 542 min() OVER ( 543 w 544 PARTITION BY a, 545 b 546 ORDER BY x, 547 y 548 ROWS BETWEEN 549 1 FOLLOWING 550 AND 551 1 FOLLOWING 552 ) 553 554 25: 555 ------------------------- 556 SELECT min(a, b), 557 min( 558 DISTINCT 559 a, 560 b 561 ), 562 min(), 563 min() OVER (), 564 min() OVER ( 565 ORDER BY x 566 ), 567 min() FILTER ( 568 WHERE x > 3 569 AND y < 4 570 ), 571 min() FILTER ( 572 WHERE x > 3 573 AND y < 4 574 ) OVER ( 575 ORDER BY x 576 ), 577 min() OVER ( 578 RANGE BETWEEN 579 UNBOUNDED PRECEDING 580 AND 581 UNBOUNDED FOLLOWING 582 ), 583 min() OVER ( 584 ROWS BETWEEN 585 1 FOLLOWING 586 AND 587 1 FOLLOWING 588 ), 589 min() OVER ( 590 w 591 PARTITION BY a, b 592 ORDER BY x, y 593 ROWS BETWEEN 594 1 FOLLOWING 595 AND 596 1 FOLLOWING 597 ) 598 599 26: 600 -------------------------- 601 SELECT min(a, b), 602 min(DISTINCT a, b), 603 min(), 604 min() OVER (), 605 min() OVER ( 606 ORDER BY x 607 ), 608 min() FILTER ( 609 WHERE x > 3 610 AND y < 4 611 ), 612 min() FILTER ( 613 WHERE x > 3 614 AND y < 4 615 ) OVER ( 616 ORDER BY x 617 ), 618 min() OVER ( 619 RANGE BETWEEN 620 UNBOUNDED PRECEDING 621 AND 622 UNBOUNDED FOLLOWING 623 ), 624 min() OVER ( 625 ROWS BETWEEN 626 1 FOLLOWING 627 AND 628 1 FOLLOWING 629 ), 630 min() OVER ( 631 w 632 PARTITION BY a, b 633 ORDER BY x, y 634 ROWS BETWEEN 635 1 FOLLOWING 636 AND 637 1 FOLLOWING 638 ) 639 640 27: 641 --------------------------- 642 SELECT min(a, b), 643 min(DISTINCT a, b), 644 min(), 645 min() OVER (), 646 min() OVER ( 647 ORDER BY x 648 ), 649 min() FILTER ( 650 WHERE x > 3 651 AND y < 4 652 ), 653 min() FILTER ( 654 WHERE x > 3 655 AND y < 4 656 ) OVER (ORDER BY x), 657 min() OVER ( 658 RANGE BETWEEN 659 UNBOUNDED PRECEDING 660 AND 661 UNBOUNDED FOLLOWING 662 ), 663 min() OVER ( 664 ROWS BETWEEN 665 1 FOLLOWING 666 AND 667 1 FOLLOWING 668 ), 669 min() OVER ( 670 w 671 PARTITION BY a, b 672 ORDER BY x, y 673 ROWS BETWEEN 674 1 FOLLOWING 675 AND 676 1 FOLLOWING 677 ) 678 679 29: 680 ----------------------------- 681 SELECT min(a, b), 682 min(DISTINCT a, b), 683 min(), 684 min() OVER (), 685 min() OVER ( 686 ORDER BY x 687 ), 688 min() FILTER ( 689 WHERE x > 3 AND y < 4 690 ), 691 min() FILTER ( 692 WHERE x > 3 AND y < 4 693 ) OVER (ORDER BY x), 694 min() OVER ( 695 RANGE BETWEEN 696 UNBOUNDED PRECEDING 697 AND 698 UNBOUNDED FOLLOWING 699 ), 700 min() OVER ( 701 ROWS BETWEEN 702 1 FOLLOWING 703 AND 704 1 FOLLOWING 705 ), 706 min() OVER ( 707 w 708 PARTITION BY a, b 709 ORDER BY x, y 710 ROWS BETWEEN 711 1 FOLLOWING 712 AND 713 1 FOLLOWING 714 ) 715 716 31: 717 ------------------------------- 718 SELECT min(a, b), 719 min(DISTINCT a, b), 720 min(), 721 min() OVER (), 722 min() OVER (ORDER BY x), 723 min() FILTER ( 724 WHERE x > 3 AND y < 4 725 ), 726 min() FILTER ( 727 WHERE x > 3 AND y < 4 728 ) OVER (ORDER BY x), 729 min() OVER ( 730 RANGE BETWEEN 731 UNBOUNDED PRECEDING 732 AND 733 UNBOUNDED FOLLOWING 734 ), 735 min() OVER ( 736 ROWS BETWEEN 737 1 FOLLOWING 738 AND 739 1 FOLLOWING 740 ), 741 min() OVER ( 742 w 743 PARTITION BY a, b 744 ORDER BY x, y 745 ROWS BETWEEN 746 1 FOLLOWING 747 AND 748 1 FOLLOWING 749 ) 750 751 32: 752 -------------------------------- 753 SELECT min(a, b), 754 min(DISTINCT a, b), 755 min(), 756 min() OVER (), 757 min() OVER (ORDER BY x), 758 min() FILTER ( 759 WHERE x > 3 AND y < 4 760 ), 761 min() FILTER ( 762 WHERE x > 3 AND y < 4 763 ) OVER (ORDER BY x), 764 min() OVER ( 765 RANGE BETWEEN 766 UNBOUNDED PRECEDING 767 AND 768 UNBOUNDED FOLLOWING 769 ), 770 min() OVER ( 771 ROWS BETWEEN 1 FOLLOWING 772 AND 1 FOLLOWING 773 ), 774 min() OVER ( 775 w 776 PARTITION BY a, b 777 ORDER BY x, y 778 ROWS BETWEEN 779 1 FOLLOWING 780 AND 781 1 FOLLOWING 782 ) 783 784 40: 785 ---------------------------------------- 786 SELECT min(a, b), 787 min(DISTINCT a, b), 788 min(), 789 min() OVER (), 790 min() OVER (ORDER BY x), 791 min() FILTER ( 792 WHERE x > 3 AND y < 4 793 ), 794 min() FILTER ( 795 WHERE x > 3 AND y < 4 796 ) OVER (ORDER BY x), 797 min() OVER ( 798 RANGE BETWEEN 799 UNBOUNDED PRECEDING 800 AND 801 UNBOUNDED FOLLOWING 802 ), 803 min() OVER ( 804 ROWS BETWEEN 1 FOLLOWING 805 AND 1 FOLLOWING 806 ), 807 min() OVER ( 808 w 809 PARTITION BY a, b 810 ORDER BY x, y 811 ROWS BETWEEN 1 FOLLOWING 812 AND 1 FOLLOWING 813 ) 814 815 41: 816 ----------------------------------------- 817 SELECT min(a, b), 818 min(DISTINCT a, b), 819 min(), 820 min() OVER (), 821 min() OVER (ORDER BY x), 822 min() FILTER ( 823 WHERE x > 3 AND y < 4 824 ), 825 min() FILTER ( 826 WHERE x > 3 AND y < 4 827 ) OVER (ORDER BY x), 828 min() OVER ( 829 RANGE BETWEEN UNBOUNDED PRECEDING 830 AND UNBOUNDED FOLLOWING 831 ), 832 min() OVER ( 833 ROWS BETWEEN 1 FOLLOWING 834 AND 1 FOLLOWING 835 ), 836 min() OVER ( 837 w 838 PARTITION BY a, b 839 ORDER BY x, y 840 ROWS BETWEEN 1 FOLLOWING 841 AND 1 FOLLOWING 842 ) 843 844 44: 845 -------------------------------------------- 846 SELECT min(a, b), 847 min(DISTINCT a, b), 848 min(), 849 min() OVER (), 850 min() OVER (ORDER BY x), 851 min() FILTER (WHERE x > 3 AND y < 4), 852 min() FILTER ( 853 WHERE x > 3 AND y < 4 854 ) OVER (ORDER BY x), 855 min() OVER ( 856 RANGE BETWEEN UNBOUNDED PRECEDING 857 AND UNBOUNDED FOLLOWING 858 ), 859 min() OVER ( 860 ROWS BETWEEN 1 FOLLOWING 861 AND 1 FOLLOWING 862 ), 863 min() OVER ( 864 w 865 PARTITION BY a, b 866 ORDER BY x, y 867 ROWS BETWEEN 1 FOLLOWING 868 AND 1 FOLLOWING 869 ) 870 871 48: 872 ------------------------------------------------ 873 SELECT min(a, b), 874 min(DISTINCT a, b), 875 min(), 876 min() OVER (), 877 min() OVER (ORDER BY x), 878 min() FILTER (WHERE x > 3 AND y < 4), 879 min() FILTER ( 880 WHERE x > 3 AND y < 4 881 ) OVER (ORDER BY x), 882 min() OVER ( 883 RANGE BETWEEN UNBOUNDED PRECEDING 884 AND UNBOUNDED FOLLOWING 885 ), 886 min() OVER ( 887 ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING 888 ), 889 min() OVER ( 890 w 891 PARTITION BY a, b 892 ORDER BY x, y 893 ROWS BETWEEN 1 FOLLOWING 894 AND 1 FOLLOWING 895 ) 896 897 50: 898 -------------------------------------------------- 899 SELECT min(a, b), 900 min(DISTINCT a, b), 901 min(), 902 min() OVER (), 903 min() OVER (ORDER BY x), 904 min() FILTER (WHERE x > 3 AND y < 4), 905 min() FILTER (WHERE x > 3 AND y < 4) OVER ( 906 ORDER BY x 907 ), 908 min() OVER ( 909 RANGE BETWEEN UNBOUNDED PRECEDING 910 AND UNBOUNDED FOLLOWING 911 ), 912 min() OVER ( 913 ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING 914 ), 915 min() OVER ( 916 w 917 PARTITION BY a, b 918 ORDER BY x, y 919 ROWS BETWEEN 1 FOLLOWING 920 AND 1 FOLLOWING 921 ) 922 923 56: 924 -------------------------------------------------------- 925 SELECT min(a, b), 926 min(DISTINCT a, b), 927 min(), 928 min() OVER (), 929 min() OVER (ORDER BY x), 930 min() FILTER (WHERE x > 3 AND y < 4), 931 min() FILTER (WHERE x > 3 AND y < 4) OVER ( 932 ORDER BY x 933 ), 934 min() OVER ( 935 RANGE BETWEEN UNBOUNDED PRECEDING 936 AND UNBOUNDED FOLLOWING 937 ), 938 min() OVER ( 939 ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING 940 ), 941 min() OVER ( 942 w 943 PARTITION BY a, b 944 ORDER BY x, y 945 ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING 946 ) 947 948 61: 949 ------------------------------------------------------------- 950 SELECT min(a, b), 951 min(DISTINCT a, b), 952 min(), 953 min() OVER (), 954 min() OVER (ORDER BY x), 955 min() FILTER (WHERE x > 3 AND y < 4), 956 min() FILTER (WHERE x > 3 AND y < 4) OVER ( 957 ORDER BY x 958 ), 959 min() OVER ( 960 RANGE BETWEEN UNBOUNDED PRECEDING 961 AND UNBOUNDED FOLLOWING 962 ), 963 min() OVER (ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING), 964 min() OVER ( 965 w 966 PARTITION BY a, b 967 ORDER BY x, y 968 ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING 969 ) 970 971 62: 972 -------------------------------------------------------------- 973 SELECT min(a, b), 974 min(DISTINCT a, b), 975 min(), 976 min() OVER (), 977 min() OVER (ORDER BY x), 978 min() FILTER (WHERE x > 3 AND y < 4), 979 min() FILTER (WHERE x > 3 AND y < 4) OVER (ORDER BY x), 980 min() OVER ( 981 RANGE BETWEEN UNBOUNDED PRECEDING 982 AND UNBOUNDED FOLLOWING 983 ), 984 min() OVER (ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING), 985 min() OVER ( 986 w 987 PARTITION BY a, b 988 ORDER BY x, y 989 ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING 990 ) 991 992 65: 993 ----------------------------------------------------------------- 994 SELECT min(a, b), 995 min(DISTINCT a, b), 996 min(), 997 min() OVER (), 998 min() OVER (ORDER BY x), 999 min() FILTER (WHERE x > 3 AND y < 4), 1000 min() FILTER (WHERE x > 3 AND y < 4) OVER (ORDER BY x), 1001 min() OVER ( 1002 RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING 1003 ), 1004 min() OVER (ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING), 1005 min() OVER ( 1006 w 1007 PARTITION BY a, b 1008 ORDER BY x, y 1009 ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING 1010 ) 1011 1012 78: 1013 ------------------------------------------------------------------------------ 1014 SELECT min(a, b), 1015 min(DISTINCT a, b), 1016 min(), 1017 min() OVER (), 1018 min() OVER (ORDER BY x), 1019 min() FILTER (WHERE x > 3 AND y < 4), 1020 min() FILTER (WHERE x > 3 AND y < 4) OVER (ORDER BY x), 1021 min() OVER (RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING), 1022 min() OVER (ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING), 1023 min() OVER ( 1024 w 1025 PARTITION BY a, b 1026 ORDER BY x, y 1027 ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING 1028 ) 1029 1030 82: 1031 ---------------------------------------------------------------------------------- 1032 SELECT min(a, b), 1033 min(DISTINCT a, b), 1034 min(), 1035 min() OVER (), 1036 min() OVER (ORDER BY x), 1037 min() FILTER (WHERE x > 3 AND y < 4), 1038 min() FILTER (WHERE x > 3 AND y < 4) OVER (ORDER BY x), 1039 min() OVER (RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING), 1040 min() OVER (ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING), 1041 min() OVER ( 1042 w PARTITION BY a, b ORDER BY x, y ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING 1043 ) 1044 1045 94: 1046 ---------------------------------------------------------------------------------------------- 1047 SELECT min(a, b), 1048 min(DISTINCT a, b), 1049 min(), 1050 min() OVER (), 1051 min() OVER (ORDER BY x), 1052 min() FILTER (WHERE x > 3 AND y < 4), 1053 min() FILTER (WHERE x > 3 AND y < 4) OVER (ORDER BY x), 1054 min() OVER (RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING), 1055 min() OVER (ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING), 1056 min() OVER (w PARTITION BY a, b ORDER BY x, y ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING) 1057 1058 393: 1059 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1060 SELECT min(a, b), min(DISTINCT a, b), min(), min() OVER (), min() OVER (ORDER BY x), min() FILTER (WHERE x > 3 AND y < 4), min() FILTER (WHERE x > 3 AND y < 4) OVER (ORDER BY x), min() OVER (RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING), min() OVER (ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING), min() OVER (w PARTITION BY a, b ORDER BY x, y ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING) 1061 1062