[sqlalchemy] sqlalchemy.func.sum

[Ash]

Hello ,

I am usinng sqlalchemy for making the sum on column i am using
sqlalchemy.func.sum (col_name).

I am getting the error while dng it .

Code snnipet
----------------
aggregator=sqlalchemy.func.sum('product_sold')
make_select = sqlalchemy.select(from_obj=[sales],columns=
[aggregator],distinct=True)
query = make_select.execute()
result = query.fetchall()


Error trace
----------

    query = make_select.execute()
  File "/var/lib/python-support/python2.5/sqlalchemy/sql/
expression.py", line 1087, in execute
    return e.execute_clauseelement(self, multiparams, params)
  File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py",
line 1219, in execute_clauseelement
    return connection.execute_clauseelement(elem, multiparams, params)
  File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py",
line 895, in execute_clauseelement
    return self._execute_compiled(elem.compile(dialect=self.dialect,
column_keys=keys, inline=len(params) > 1), distilled_params=params)
  File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py",
line 907, in _execute_compiled
    self.__execute_raw(context)
  File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py",
line 916, in __execute_raw
    self._cursor_execute(context.cursor, context.statement,
context.parameters[0], context=context)
  File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py",
line 960, in _cursor_execute
    self._handle_dbapi_exception(e, statement, parameters, cursor)
  File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py",
line 942, in _handle_dbapi_exception
    raise exceptions.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
sqlalchemy.exceptions.ProgrammingError: (ProgrammingError) function sum
(unknown) is not unique


Thanks in advance
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---