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 -~----------~----~----~----~------~----~------~--~---