--Sam

On Sat, Dec 26, 2009 at 10:12 AM, Ivan Boldyrev <lispnik@gmail.com> wrote:

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

_______________________________________________
postmodern-devel mailing list
postmodern-devel@common-lisp.net
http://common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel

--
Sam Alves
Package Maintainer
OSHEAN, Inc.
Email: sam@oshean.org