On Tuesday, March 22, 2016, Michael Moore <michaeljmoore(at)gmail(dot)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