Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

Next:From: John R PierceDate: 2005-09-19 22:59:18
Subject: Re: UPDATE with database name alias
Previous:From: andresDate: 2005-09-19 20:47:00
Subject: Re: UPDATE with database name alias

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group