On Sat, Dec 26, 2009 at 8:23 PM, Sam Alves <sam@oshean.org> wrote:

Here's my best attempt:

    :SELECT '* :FROM 'filter

    :WHERE 'title

    :IN (:SELECT 'filter_title :FROM user_filter :WHERE (:= 'user-id 3))

However, I get the following error:

    Keyword WHERE takes exactly one argument

I've tried the SQL query in psql so I know it works, but I can't seem to come up with an equivalent s-sql statement.



(:select '* :from 'filter :where
    (:in 'title (:SELECT 'filter_title :FROM user_filter :WHERE (:= 'user-id 3))))

--
Ivan Boldyrev