On 12/10/2013 09:39 AM, Teodor Sigaev wrote:
> 
> SELECT
>     *
> FROM
>     t
> WHERE (
>     CASE
>         WHEN a%2 IN (SELECT c FROM tt) THEN a
>     END IN (SELECT c FROM tt)
> );

Wow, it wouldn't have occured to me that that was even supported syntax.
 I'm not suprised that it doesn't work ...


-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to