Sorry,
but I don't understand how create, insert or select data with the array
field in postgres.
if I try to do somethong like this
users = Table('prova', metadata,
Column('user_id', Integer, primary_key=True),
Column('name', String(40)),
Column('some_numbers', Integer[4]),
)
users.create()
python tell that colum some_numbers is an unsuscriptable object and
Integer[] is an invalid sintax.
I create directly the tables in postgres, than I can insert data
because
table.insert({'user_id':1, name':'Bill', 'color':'ARRAY{1, 3,
5}').execute() return key error: int[].
I read the documentation but I don't found the solution.
thanks for the help
luca
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
