Re: Error in Update and Set statement

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Error in Update and Set statement
Date: 2016-01-20 10:47:59
Message-ID: CAFj8pRCXwqWEDrG1BRzq+Y2G77DFxhC06z8A1OoZaHS_=vKd8g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

2016-01-20 11:45 GMT+01:00 Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com>:

> Boss !!
>
> I am using postgres 9.4, so how to handle this.
>
>
I don't know Ora2Pg - try to find some option to generate in old format -
or manually rewrite to supported syntax

UPDATE tab SET a = x.a, ... FROM x

Regards

Pavel

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Rogerson 2016-01-20 11:10:53 Postgres and timezones
Previous Message Sachin Srivastava 2016-01-20 10:45:31 Re: Error in Update and Set statement