Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-746

Implements function COALESCE

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.8.0
    • Component/s: None
    • Labels:
      None

      Description

      See title.
      The next description is from the postgresql document(http://www.postgresql.org/docs/9.1/static/functions-conditional.html).

      COALESCE(value [, ...])
      

      The COALESCE function returns the first of its arguments that is not null. Null is returned only if all arguments are null. It is often used to substitute a default value for null values when data is retrieved for display, for example:

      SELECT COALESCE(description, short_description, '(none)') ...
      

      Like a CASE expression, COALESCE only evaluates the arguments that are needed to determine the result; that is, arguments to the right of the first non-null argument are not evaluated. This SQL-standard function provides capabilities similar to NVL and IFNULL, which are used in some other database systems.

        Attachments

        1. TAJO-746.patch
          31 kB
          Hyoungjun Kim
        2. TAJO-746_2.patch
          43 kB
          Hyunsik Choi

          Activity

            People

            • Assignee:
              hjkim Hyoungjun Kim
              Reporter:
              hjkim Hyoungjun Kim
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: