simple function index question

From: Michael Moore <michaeljmoore(at)gmail(dot)com>
To: postgres list <pgsql-sql(at)postgresql(dot)org>
Subject: simple function index question
Date: 2016-03-23 00:23:50
Message-ID: CACpWLjPDmEqqu4DcuOPH_EfmrZPshW-aN9Wq+GBXOZf-ZvHrHA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

*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?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David G. Johnston 2016-03-23 00:39:24 Re: simple function index question
Previous Message Michael Moore 2016-03-21 18:38:47 Re: recursive WITH nested union ALL with NOCYCLE logic