Hi All,
I'm trying to make the following SQL statement lispy by converting it to s-sql:
SELECT * FROM filter
WHERE title
IN ( SELECT filter_title FROM user_filter WHERE user_id = 4);
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.
Thanks for any assistance,
Sam
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 argumentI'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))))
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 argumentI'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
postmodern-devel@common-lisp.net
-
Ivan Boldyrev -
Sam Alves