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

Implements function COALESCE

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 0.8.0
    • None
    • 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_2.patch
          43 kB
          Hyunsik Choi
        2. TAJO-746.patch
          31 kB
          Hyoungjun Kim

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: