hi i would like to use idea in book Application Development Cookbook - Efficienty search by tag. there are two functions: 'search_or' and 'search_and' everything is working fine on sqlite when i switch to postgres, there seems to be problem with 'groupby'. i got an error
<class 'psycopg2.ProgrammingError'> column "data.value" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT DISTINCT data.id, data.value FROM tag, data WHERE ((d... ^ when i remove 'groupby=....id" there is no error, but (of course) 'search_and' function doesn't work properly is this a bug related to postgres? andrej --
