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
Re: simple function index question |
| Список | 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 recordJust 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 по дате отправления: