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

[Sam Alves]

Thanks, it worked!

--Sam

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

>
>
> On Sat, Dec 26, 2009 at 8:23 PM, Sam Alves <sam at 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 at common-lisp.net
> http://common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel
>
>


-- 
Sam Alves
Package Maintainer
OSHEAN, Inc.
Email: sam at oshean.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.common-lisp.net/pipermail/postmodern-devel/attachments/20091226/e4fbc518/attachment.html>