[storm] Oracle sequence columns

Jamu Kakar jkakar at kakar.ca
Sat Dec 5 01:19:22 GMT 2009


Hi Vernon,

On Fri, Dec 4, 2009 at 5:11 PM, Vernon Cole <vernondcole at gmail.com> wrote:
> Some syntax like this would be REALLY helpful for supporting MS SQL,
> too.  MS will increment the value for you, but then you need to ask it
> to tell you what number it assigned.  A clue that we have an
> autoincrement field would tell us when to go hunting for the new
> value.

I don't think this is actually necessary.  Each backend is able to,
as needed, provide support for this behaviour (for primary keys).
Search for get_insert_identity if you're curious about the way this
works.

Thanks,
J.



More information about the storm mailing list