Re: simple function index question

Поиск
Список
Период
Сортировка
От Michael Moore
Тема Re: simple function index question
Дата
Msg-id CACpWLjPNQEUTc49OuWKA5U0qs7-cVmP1J_u_GECv-BS5Eciteg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: simple function index question  (Rosser Schwarz <rosser.schwarz@gmail.com>)
Ответы Re: simple function index question  (bricklen <bricklen@gmail.com>)
Re: simple function index question  (Igor Neyman <ineyman@perceptron.com>)
Список pgsql-sql
Thanks guys,
I agree that the data model is suspect. I'm trying to convert from Oracle to Postgres and changing table structures is not really an option for me. I tried casting the null, ... same problem. It does not like the undefined record type as David is saying. I will try his solution and let you know how it goes.


On Tue, Mar 22, 2016 at 5:54 PM, Rosser Schwarz <rosser.schwarz@gmail.com> wrote:
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 по дате отправления:

Предыдущее
От: Igor Neyman
Дата:
Сообщение: Re: simple function index question
Следующее
От: bricklen
Дата:
Сообщение: Re: simple function index question