Re: [sqlalchemy] how to add an order column to an existing table

2014-10-13 Thread Michael Bayer
perly ended" > I'm unfamiliar with this syntax (update ... from ... where). Was this > properly constructed? > > > From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On > Behalf Of Michael Bayer > Sent: Monday, October 13, 2014 8:53 PM >

Re: [sqlalchemy] how to add an order column to an existing table

2014-10-13 Thread Michael Bayer
... from ... where). Was this > properly constructed? > > > From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On > Behalf Of Michael Bayer > Sent: Monday, October 13, 2014 8:53 PM > To: sqlalchemy@googlegroups.com > Subject: Re: [sqlalchemy] how

RE: [sqlalchemy] how to add an order column to an existing table

2014-10-13 Thread Ofir Herzas
mmand not properly ended" I'm unfamiliar with this syntax (update . from . where). Was this properly constructed? From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On Behalf Of Michael Bayer Sent: Monday, October 13, 2014 8:53 PM To: sqlalchemy@googlegroups.com

Re: [sqlalchemy] how to add an order column to an existing table

2014-10-13 Thread Michael Bayer
in Oracle I'd update the table based on a SELECT from a window function: SELECT row number OVER (PARTITION BY employee_id ORDER BY id) FROM employee that should give you "1, 2, 3, ..." for each row within an employee id group On Oct 13, 2014, at 1:44 PM, Ofir Herzas wrote: > I have found a so