Re: Function error

Because I have migrated the database from Oracle to Postgres through ORA2PG.

So how I will change it, please suggest.

On Fri, Jan 8, 2016 at 2:54 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
wrote:

>
>
> 2016-01-08 10:08 GMT+01:00 Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com>:
>
>> Hi,
>>
>> I am also getting "syntax error for below function (just some lines of
>> function where I am getting syntax error), please suggest why?
>>
>
> Using Oracle's outer join syntax, not ANSI SQL syntax
>
> Regards
>
> Pavel
>
>
>> --------------------
>>
>> -- Image path
>> AND mk1.subscriber_id(+)=pcat_catalog_item.subscriber_id
>> AND cs1.subscriber_id(+)=pcat_catalog_item.subscriber_id
>> AND cs1.company_id(+)=pcat_catalog_item.company_id
>> AND
>> pcat_catalog_dup_detail.dest_subscriber_id(+)=pcat_item_categorization.subscriber_id
>> AND
>> pcat_catalog_dup_detail.dest_supplier_company_id(+)=pcat_item_categorization.item_company_id
>> AND
>> pcat_catalog_dup_detail.dest_catalog_code(+)=pcat_item_categorization.catalog_code
>> AND mk2.subscriber_id(+)=pcat_catalog_dup_detail.subscriber_id
>> AND cs2.subscriber_id(+)=pcat_catalog_dup_detail.subscriber_id
>> AND cs2.company_id(+)=pcat_catalog_dup_detail.company_id;
>>
>> --------------------------
>>
>>
>> ERROR: syntax error at or near ")"
>> LINE 216: AND mk1.subscriber_id(+)=pcat_catalog_item.subscribe...
>> ^
>> ********** Error **********
>> ERROR: syntax error at or near ")"
>> SQL state: 42601
>> Character: 10018
>>
>> Regards
>> SS
>>
>>
>