Re: simple function index question - Mailing list pgsql-sql

From Rosser Schwarz
Subject Re: simple function index question
Date
Msg-id CAFnxYwjm3BjTy6pLxL3DNSrovxbqAU5wVPzyp-JjfOc7Bv2DTw@mail.gmail.com
Whole thread Raw
In response to simple function index question  (Michael Moore <michaeljmoore@gmail.com>)
Responses Re: simple function index question
List pgsql-sql
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

pgsql-sql by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: simple function index question
Next
From: Igor Neyman
Date:
Subject: Re: simple function index question