Re: CASE expression of postgresql

Kevin Rosenberg <kevin-HJRc7zDS/[email protected]>
Newsgroups gmane.lisp.clsql.devel
Message-ID <[email protected]> 
Igor Plekhov wrote:
> How can I write the following query in clsql ?
> SELECT foo, CASE foo = 1 THEN 2 END
> FROM bar;

Just the plain ASCII string should work:
  (clsql:select "SELECT foo, CASE foo = 1 THEN 2 END FROM bar")

Kevin
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.