Re: UPDATE with database name alias

From: Kris Jurka <books(at)ejurka(dot)com>
To: andres(at)sayago(dot)info
Cc: Dave Cramer <pg(at)fastcrypt(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: UPDATE with database name alias
Date: 2005-09-19 22:46:01
Message-ID: Pine.BSO.4.62.0509191743560.15690@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Mon, 19 Sep 2005 andres(at)sayago(dot)info wrote:

> JDeveloper use alias to UPDATE, an dthen, what can I do?
>

Your only option would be to ajdust the postgresql backend grammar to
allow an alias.

> PostgreSQL don't use alias to UPATE? Never?
>

Right, the SQL standard does not allow aliases on UPDATEs and neither does
postgresql.

Kris Jurka

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message John R Pierce 2005-09-19 22:59:18 Re: UPDATE with database name alias
Previous Message andres 2005-09-19 20:47:00 Re: UPDATE with database name alias