CASE expression of postgresql

Igor Plekhov <[email protected]> Fri, 12 Aug 2005 16:00:06 +1100

Newsgroups	gmane.lisp.clsql.devel
Message-ID	<20050812050006.GC28725@tcp>

How can I write the following query in clsql ?

SELECT foo, CASE foo = 1 THEN 2 END
FROM bar;

foo is a column of bar table;
CASE is a conditional expression of postgresql.


-- 
Registered Linux User #124759

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.