Re: simple function index question

On Tuesday, March 22, 2016, Michael Moore <michaeljmoore(at)gmail(dot)com> wrote:

> *This:*
> CREATE INDEX TX_QSET_DIR_MAP_PRI_URI_TYP_UK
> ON tx_question_set_dir_map
> USING btree
> ((
> CASE
> WHEN uri_type = 201900 then
> (question_set2tx_question_set ,uri_type, null)
> ELSE
> (question_set2tx_question_set ,uri_type, question_set_dir_map_key)
> END))
> TABLESPACE qsn_indx_ol;
>
> *results in*
> ERROR: column "" has pseudo-type record
> ********** Error **********
>
> ERROR: column "" has pseudo-type record
> SQL state: 42P16
>
> Hopefully it is clear what I am attempting to do here. How do I make this
> happen?
>

I suspect the system dislikes your attempt to use an anonymous composite as
a column in an index.

I question whether what you are trying to do resembles good data modeling.
But if you must you can probably define Ana,Ed composite type and cast the
result of the case to it.

David J.