Re: Function error

Thanks Pavel for your help !!!

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

>
>
> 2016-01-08 10:52 GMT+01:00 Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com>:
>
>> Because I have migrated the database from Oracle to Postgres through
>> ORA2PG.
>>
>> So how I will change it, please suggest.
>>
>
>
> http://stackoverflow.com/questions/2269156/converting-from-oracle-join-to-postgres-join
>
>
>> 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
>>>>
>>>>
>>>
>>
>