github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/eval/infinity (about)

     1  eval
     2  power(0::decimal, -1)
     3  ----
     4  Infinity
     5  
     6  # Infinities
     7  
     8  eval
     9  'Infinity'::float
    10  ----
    11  +Inf
    12  
    13  eval
    14  '+Infinity'::float
    15  ----
    16  +Inf
    17  
    18  eval
    19  '-Infinity'::float
    20  ----
    21  -Inf
    22  
    23  eval
    24  'Inf'::float
    25  ----
    26  +Inf
    27  
    28  eval
    29  '+Inf'::float
    30  ----
    31  +Inf
    32  
    33  eval
    34  '-Inf'::float
    35  ----
    36  -Inf
    37  
    38  eval
    39  'Inf'::float(4)
    40  ----
    41  +Inf
    42  
    43  eval
    44  '-Inf'::real
    45  ----
    46  -Inf
    47  
    48  eval
    49  '+Infinity'::double precision
    50  ----
    51  +Inf
    52  
    53  eval
    54  '+Inf'::float < 1.0
    55  ----
    56  false
    57  
    58  eval
    59  '+Inf'::float <= 1.0
    60  ----
    61  false
    62  
    63  eval
    64  '+Inf'::float = 1.0
    65  ----
    66  false
    67  
    68  eval
    69  '+Inf'::float > 1.0
    70  ----
    71  true
    72  
    73  eval
    74  '+Inf'::float >= 1.0
    75  ----
    76  true
    77  
    78  eval
    79  '-Inf'::float < 1.0
    80  ----
    81  true
    82  
    83  eval
    84  '-Inf'::float <= 1.0
    85  ----
    86  true
    87  
    88  eval
    89  '-Inf'::float = 1.0
    90  ----
    91  false
    92  
    93  eval
    94  '-Inf'::float > 1.0
    95  ----
    96  false
    97  
    98  eval
    99  '-Inf'::float >= 1.0
   100  ----
   101  false
   102  
   103  eval
   104  '-Inf'::float < '+Inf'::float
   105  ----
   106  true
   107  
   108  eval
   109  '-Inf'::float <= '+Inf'::float
   110  ----
   111  true
   112  
   113  eval
   114  '-Inf'::float = '+Inf'::float
   115  ----
   116  false
   117  
   118  eval
   119  '-Inf'::float > '+Inf'::float
   120  ----
   121  false
   122  
   123  eval
   124  '-Inf'::float >= '+Inf'::float
   125  ----
   126  false
   127  
   128  eval
   129  'Infinity'::decimal
   130  ----
   131  Infinity
   132  
   133  eval
   134  '+Infinity'::decimal
   135  ----
   136  Infinity
   137  
   138  eval
   139  '-Infinity'::decimal
   140  ----
   141  -Infinity
   142  
   143  eval
   144  'Inf'::decimal
   145  ----
   146  Infinity
   147  
   148  eval
   149  '+Inf'::decimal
   150  ----
   151  Infinity
   152  
   153  eval
   154  '-Inf'::decimal
   155  ----
   156  -Infinity
   157  
   158  eval
   159  'Inf'::decimal(4)
   160  ----
   161  Infinity
   162  
   163  eval
   164  '+Inf'::decimal < 1.0
   165  ----
   166  false
   167  
   168  eval
   169  '+Inf'::decimal <= 1.0
   170  ----
   171  false
   172  
   173  eval
   174  '+Inf'::decimal = 1.0
   175  ----
   176  false
   177  
   178  eval
   179  '+Inf'::decimal > 1.0
   180  ----
   181  true
   182  
   183  eval
   184  '+Inf'::decimal >= 1.0
   185  ----
   186  true
   187  
   188  eval
   189  '-Inf'::decimal < 1.0
   190  ----
   191  true
   192  
   193  eval
   194  '-Inf'::decimal <= 1.0
   195  ----
   196  true
   197  
   198  eval
   199  '-Inf'::decimal = 1.0
   200  ----
   201  false
   202  
   203  eval
   204  '-Inf'::decimal > 1.0
   205  ----
   206  false
   207  
   208  eval
   209  '-Inf'::decimal >= 1.0
   210  ----
   211  false
   212  
   213  eval
   214  '-Inf'::decimal < '+Inf'::decimal
   215  ----
   216  true
   217  
   218  eval
   219  '-Inf'::decimal <= '+Inf'::decimal
   220  ----
   221  true
   222  
   223  eval
   224  '-Inf'::decimal = '+Inf'::decimal
   225  ----
   226  false
   227  
   228  eval
   229  '-Inf'::decimal > '+Inf'::decimal
   230  ----
   231  false
   232  
   233  eval
   234  '-Inf'::decimal >= '+Inf'::decimal
   235  ----
   236  false
   237  
   238  eval
   239  'Inf'::decimal::float
   240  ----
   241  +Inf
   242  
   243  eval
   244  'Inf'::float::decimal
   245  ----
   246  Infinity