关于数据库表，多条查询的问题。

[p8p8]

user表里有N条记录，表里有3个字段，uid, username, avatar，这个时候，客户端post给服务端一个用户uid的字典，例如{123,332,190,201}，那么我如何根据这些传过来的uid，查询到数据后，返回给客户端这4个uid数据库表字段中的username和avatar啊？

[saximoer]

返回几个User 对象的LIST 或者转成JSON 呗~
不晓得有没有帮助

[maroon]

select * from user where id in (1,2,3,4);

[p8p8]

@tornado.gen.coroutine
def get_myfriens(self,friends):
query = 'SELECT username, avatar_url FROM users WHERE mid IN (759428,480672);'
cursor = yield self.execute(query)


这样会报错：

psycopg2.ProgrammingError: operator does not exist: text = integer
LINE 1: SELECT username, avatar_url FROM users WHERE mid in (759428,...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

[p8p8]

是我自己字段的问题，设置好了，谢谢大家！