On Tuesday, March 22, 2016, Michael Moore <
michaeljmoore@gmail.com> wrote:
ERROR: column "" has pseudo-type record
Just guessing, and don't have time to verify, but you might try casting the null value in the WHEN clause to the same type as the question_set_dir_map_key column in the ELSE clause.
I'd probably also try doing this with two separate indexes; this feels a bit like it might asking the one index to do too much.
--
:wq