0004804: m_get_offers_name function does not work on postgreSQL

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0004804

Openbravo ERP

Z. Others

public

2008-09-03 18:24

2009-03-26 13:04

Reporter

egoitz

Assigned To

Hennadzi

Priority

normal

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

2.40

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0004804: m_get_offers_name function does not work on postgreSQL

Description

The m_get_offers_name function does not work on postgresql

Steps To Reproduce

I tried to use this function defined to do a develop.
I defined a new Price adjustemnt and assigned a product to this price adjustment. I execute the next order and it didn't return nothing.
select m_get_offers_name(to_date(now()),anypartner_id,the_id_of_the_productassigned) from dual;

Proposed Solution

The problem is that the next variable is initialized with NULL and then a String is concatened to this variable, and it is not possible in postgre.

v_Names VARCHAR(10000) := NULL;
...
...
    LOOP
      IF v_Names IS NOT NULL THEN
        v_Names := v_Names||'
';
      END IF;
      v_Names := v_Names||Cur_Offer.name;
    END LOOP;

To solve it you have to use an empty string instead of NULL and the compare the v_Names with an empty string instead of compare with NULL.
Posible solution:

v_Names VARCHAR(10000) := '';
...
...
IF v_Names <> '' THEN
        v_Names := v_Names||'<b r/>& nbsp;';
      END IF;
      v_Names := v_Names||Cur_Offer.name;
    END LOOP;

Additional Information