Thanks Pavel for your help !!! On Fri, Jan 8, 2016 at 3:28 PM, Pavel Stehule <pavel.steh...@gmail.com> wrote:
> > > 2016-01-08 10:52 GMT+01:00 Sachin Srivastava <ssr.teleat...@gmail.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.steh...@gmail.com> >> wrote: >> >>> >>> >>> 2016-01-08 10:08 GMT+01:00 Sachin Srivastava <ssr.teleat...@gmail.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 >>>> >>>> >>> >> >
