Attach filesAttach ScreenshotVotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 3.0.0
    • Fix Version/s: None
    • Component/s: SQL
    • Labels:
      None

      Description

      Operator Description Example Result
      ^ exponentiation (associates left to right) 2.0 ^ 3.0 8
      |/ square root |/ 25.0 5
      ||/ cube root ||/ 27.0 3
      ! factorial 5 ! 120
      !! factorial (prefix operator) !! 5 120
      @ absolute value @ -5.0 5
      # bitwise XOR 17 # 5 20
      << bitwise shift left 1 << 4 16
      >> bitwise shift right 8 >> 2 2

       
      Please note that we have ^, ! and !!, but it has different meanings.

      https://www.postgresql.org/docs/11/functions-math.html
      https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/LanguageElements/Operators/BitwiseOperators.htm
      https://docs.aws.amazon.com/redshift/latest/dg/r_OPERATOR_SYMBOLS.html

        Attachments

        Issue Links

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              yumwang Yuming Wang

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment