Postgres Pro
Downloads
Home   >   mailing lists

simple function index question - Mailing list pgsql-sql

From Michael Moore
Subject simple function index question
Date
Msg-id CACpWLjPDmEqqu4DcuOPH_EfmrZPshW-aN9Wq+GBXOZf-ZvHrHA@mail.gmail.com
Whole thread Raw
Responses Re: simple function index question
Re: simple function index question
Re: simple function index question
List pgsql-sql
Tree view
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?

pgsql-sql by date:

Previous
From: Michael Moore
Date:
Subject: Re: recursive WITH nested union ALL with NOCYCLE logic
Next
From: "David G. Johnston"
Date:
Subject: Re: simple function index question