Feature request: pgsql's CASE...WHEN optimization

[pasman pasmański <pasman.p@xxxxxxxxx>]

Hi.

I think that in specific statement with many constants:

CASE x
  WHEN const1 THEN action1
  WHEN const2 THEN action2
  WHEN const3 THEN action3
  WHEN const4 THEN action4
END CASE;

constants may be sorted at compile time, and when executed ,
it will be possible internally to use fast search:

IF x<=const2 THEN
    IF x=const1 THEN action1
                        ELSE action2
    END IF;
ELSE
     IF x=const3 THEN action3
                          ELSE action4
    END IF;
END IF;



------------
pasman

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