Re: Factoring where clauses through UNIONS take 2
От | Tom Lane |
---|---|
Тема | Re: Factoring where clauses through UNIONS take 2 |
Дата | |
Msg-id | 3600.1051228109@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: Factoring where clauses through UNIONS take 2 (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Factoring where clauses through UNIONS take 2
|
Список | pgsql-general |
I said: > In this particular case, since the qual doesn't actually touch the > type-converted column, it would have been safe to push down, but the > planner doesn't make this test on a per-qual basis: if there are type > conversions anywhere in the UNION it just punts. CVS tip has now had its consciousness raised on this point ;-). Turns out that it's not significantly more expensive to apply the test to individual vars instead of having a blanket check on the whole query, so I fixed it. Jonathan will still need to put the explicit casts into his view for use with 7.3.*, though. He probably should do that anyway, because even in 7.4 a restriction on the "type" column would not get pushed down as desired if the literals are UNKNOWN type. regards, tom lane
В списке pgsql-general по дате отправления: