Re: [postmodern-devel] Converting a SQL statement with subquery into S-SQL

Thanks, it worked!

--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