I'm new in this list, but not in the database world. I have a question and
I need yout colaboration.
I am programming with JDeveloper 10g, and I want to use PostgreSQL
database. I'm using Oracle but I wanna do the migration. But, I have a big
problem: I use PostgreSQL with ADF and ADF uses aliasses for the database
name when it need to do a UPDATE. Example:
UPDATE conference_romms ConferenceRooms
SET ConferenceRooms.room_name = 'Golden'
WHERE ConferenceRooms.room_id = 57;
That sentence fail because the UPDATE clause don't support aliasses.
I'm thinking right? Or I am mistaked.
PostgreSQL don't support database name aliasses for the UPDATE option??
How can I do it??
Bogotá D.C., Colombia
pgsql-jdbc by date
|Next:||From: Dave Cramer||Date: 2005-09-19 20:46:44|
|Subject: Re: UPDATE with database name alias|
|Previous:||From: Gianluigi||Date: 2005-09-17 11:08:48|
|Subject: GCJ jdbc driver compilation|