Re: UPDATE with database name alias - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: UPDATE with database name alias
Date
Msg-id Pine.BSO.4.62.0509191743560.15690@leary.csoft.net
Whole thread Raw
In response to Re: UPDATE with database name alias  (andres@sayago.info)
Responses Re: UPDATE with database name alias  (John R Pierce <pierce@hogranch.com>)
Re: UPDATE with database name alias  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: UPDATE with database name alias  (Vadim Nasardinov <vadimn@redhat.com>)
List pgsql-jdbc

On Mon, 19 Sep 2005 andres@sayago.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

pgsql-jdbc by date:

Previous
From: andres@sayago.info
Date:
Subject: Re: UPDATE with database name alias
Next
From: John R Pierce
Date:
Subject: Re: UPDATE with database name alias