Re: Function error

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
>>>
>>>
>>
>