On Sep 18, 2008, at 4:53 AM, GHZ wrote:
Hi,
Is there a reason why this is not used to return the id column value?
Would cut down on the number of roundtrips for insert statements
e.g.
insert into bob (id) values (bob_sq.nextval) returning id into :id
rather than what seems to be happening at the moment:
select bob_sq.nextval from dual;
insert into bob (id) values (:id);
we have this feature implemented for postgres, though it is not yet
integrated with the ORM. it would be a feature add for Oracle as
well.My oracle experience dates back to the 8 series where im not
sure if this syntax was available.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---