From: | andres(at)sayago(dot)info |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | UPDATE with database name alias |
Date: | 2005-09-19 18:08:26 |
Message-ID: | 2977.69.79.131.31.1127153306.squirrel@www.sayago.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hello friends.
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??
Thanks,
Andrés Säyago
Bogotá D.C., Colombia
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2005-09-19 20:46:44 | Re: UPDATE with database name alias |
Previous Message | Gianluigi | 2005-09-17 11:08:48 | GCJ jdbc driver compilation |